Impala select *不显示表的所有详细信息
我在impala中有一个sql查询,从表中选择*
,但是当我执行此操作时,某些列丢失了.
I have an sql query within impala select * from table
but when I execute this certain columns are missing .
当我做描述表
时,这些列在那里.
Whereas when I do describe table
those columns are there.
我无法显示代码段,但未显示的类型是地图,数组和结构.
I cannot show the snippet but the types not showing up are maps,arrays, and structs.
Impala不支持.复杂类型必须解压才能显示.
Impala doesn't support that. Complex types have to be unpacked to be displayed.
Impala查询的结果集始终包含所有标量类型;任何复杂类型查询中的元素和字段都必须是使用联接查询解压".查询无法直接检索复杂类型列的完整值.Impala在中返回错误这个案例.允许对具有复杂表的表使用SELECT *查询类型,但具有复杂类型的列将被跳过.
The result set of an Impala query always contains all scalar types; the elements and fields within any complex type queries must be "unpacked" using join queries. A query cannot directly retrieve the entire value for a complex type column. Impala returns an error in this case. Queries using SELECT * are allowed for tables with complex types, but the columns with complex types are skipped.
来源:查询和复杂类型