Impala select *不显示表的所有详细信息 [英] Impala select * does not show all details of table

问题描述

我在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.

来源:查询和复杂类型

这篇关于Impala select *不显示表的所有详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！