在Apache Impala中是否有与Hive的"explode"函数等效的函数? [英] Is there a function equivalent to Hive's 'explode' function in Apache Impala?

问题描述

Hive的功能爆炸为记录在这里 从本质上讲，这是一个非常实用的函数，可以从一个函数生成许多行.它的基本版本使用一列，该列的值是值的数组，并为每个值生成同一行的副本.

Hive's function explode is documented here It is essentially a very practical function that generates many rows from a single one. Its basic version takes a column whose value is an array of values and produces a copy of the same row for each of those values.

我想知道Impala中是否存在这样的事情.我在文档中找不到它.

I wonder whether such a thing exists in Impala. I haven't been able to find it in the documentation.

推荐答案

Impala在蜂巢中没有类似于EXPLODE的任何功能来读取复杂的数据类型并生成多行.

Impala does not have any function like EXPLODE in hive to read complex data types and generate multiple rows.

当前，通过Impala，我们可以使用像select employee.empid from table1这样的点表示法读取Hive生成的表中的复杂数据类型.

Currently through Impala, we can just read the complex data types in Hive generated tables using dot notation like select employee.empid from table1 .

Impala只能从Parquet表或分区表中的Parquet分区中查询复杂类型的列

Impala can query complex type columns only from Parquet tables or Parquet partitions within partitioned tables

这篇关于在Apache Impala中是否有与Hive的"explode"函数等效的函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！