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.

来源:查询和复杂类型