You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2020/03/13 13:47:00 UTC
[jira] [Closed] (IMPALA-3111) Selecting collection types returns
json output rather than analysis error
[ https://issues.apache.org/jira/browse/IMPALA-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabor Kaszab closed IMPALA-3111.
--------------------------------
Fix Version/s: Not Applicable
Resolution: Duplicate
> Selecting collection types returns json output rather than analysis error
> -------------------------------------------------------------------------
>
> Key: IMPALA-3111
> URL: https://issues.apache.org/jira/browse/IMPALA-3111
> Project: IMPALA
> Issue Type: New Feature
> Components: Frontend
> Affects Versions: Impala 2.3.0
> Reporter: Matthew Jacobs
> Priority: Minor
> Labels: complextype
> Fix For: Not Applicable
>
>
> Today, an outermost select list may not return collection types-- Impala now throws an AnalysisException.
> E.g.
> {code}
> [localhost:21000] > select c_orders from tpch_nested_parquet.customer limit 1;
> Query: select c_orders from tpch_nested_parquet.customer limit 1
> ERROR: AnalysisException: Expr 'c_orders' in select list returns a complex type 'ARRAY<STRUCT<o_orderkey:BIGINT,o_orderstatus:STRING,o_totalprice:DECIMAL(12,2),o_orderdate:STRING,o_orderpriority:STRING,o_clerk:STRING,o_shippriority:INT,o_comment:STRING,o_lineitems:ARRAY<STRUCT<l_partkey:BIGINT,l_suppkey:BIGINT,l_linenumber:INT,l_quantity:DECIMAL(12,2),l_extendedprice:DECIMAL(12,2),l_discount:DECIMAL(12,2),l_tax:DECIMAL(12,2),l_returnflag:STRING,l_linestatus:STRING,l_shipdate:STRING,l_commitdate:STRING,l_receiptdate:STRING,l_shipinstruct:STRING,l_shipmode:STRING,l_comment:STRING>>>>'.
> Only scalar types are allowed in the select list.
> {code}
> Instead, we should support returning collection types in the outermost select list as json strings.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org