[
https://issues.apache.org/jira/browse/IMPALA-11839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Noemi Pap-Takacs reassigned IMPALA-11839:
-----------------------------------------
Assignee: Noemi Pap-Takacs
> impala fails to read iceberg table stored as avro which has decimal(15,2)
> datatype created by hive
> --------------------------------------------------------------------------------------------------
>
> Key: IMPALA-11839
> URL: https://issues.apache.org/jira/browse/IMPALA-11839
> Project: IMPALA
> Issue Type: Bug
> Reporter: Riddhi jain
> Assignee: Noemi Pap-Takacs
> Priority: Major
> Labels: iceberg
>
> Create table using Hive
> CREATE EXTERNAL TABLE decimal_table_txt (decimal_col decimal(15,2)) ROW
> FORMAT DELIMITED FIELDS TERMINATED BY '|' stored as TEXTFILE LOCATION
> 's3a://dwx-testdata/tmp/tpch/data/customer';CREATE TABLE decimal_table STORED
> BY iceberg STORED AS avro AS SELECT * FROM decimal_table_txt;
> When trying to read iceberg table (stored as avro) using impala with
> decimal(15,2) as datatype it fails to return the rows.
> {code:java}
> select * from decimal_table;{code}
> Output:
> {code:java}
> Query 88420c9d3ee0e2f1:4ef29b2a00000000 100% Complete (2 out of 2)
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed
> Query 88420c9d3ee0e2f1:4ef29b2a00000000 100% Complete (2 out of 2)
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed
> Query 88420c9d3ee0e2f1:4ef29b2a00000000 100% Complete (2 out of 2)
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed
> Avro enum, array, map, union, and fixed types are not supported. Got type:
> fixed {code}
> {code:java}
> Done. 0 results. 88420c9d3ee0e2f1:4ef29b2a00000000{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
