[
https://issues.apache.org/jira/browse/IMPALA-3111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Kaszab updated IMPALA-3111:
---------------------------------
Labels: complextype (was: )
> 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
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
