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 "Noemi Pap-Takacs (Jira)" <ji...@apache.org> on 2023/01/16 19:14:00 UTC
[jira] [Assigned] (IMPALA-11839) impala fails to read iceberg table stored as avro which has decimal(15,2) datatype created by hive
[ 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org