sql - Impala select * 不显示表的所有详细信息

Question

我在 impala select * from table 中有一个 sql 查询，但是当我执行这个时，某些列丢失了。

而当我执行 describe table 时，那些列就在那里。

我无法显示该代码段，但未显示的类型是映射、数组 和结构。

Answer 1

Impala 不支持。复杂类型必须解包才能显示。

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.

来源:Queries and Complex Types