Gabor Kaszab created IMPALA-12457:
-------------------------------------

             Summary: Conversion from non-supported column types for Iceberg 
tables
                 Key: IMPALA-12457
                 URL: https://issues.apache.org/jira/browse/IMPALA-12457
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
            Reporter: Gabor Kaszab


Assume you have a Hive table with one VARCHAR(N) column. The following now 
fails:

CREATE TABLE ice_tbl STORED AS ICEBERG AS SELECT * FROM hive_tbl;

Fails because varchar(N) is not a supported Iceberg column type. Note, simple 
varchar works because it's just a string under the hood.

I think this behaviour is just fine, Hive also gives an error for the above, 
however, Hive has a switch called 'iceberg.mr.schema.auto.conversion' that when 
you turn on Hive would do a conversion into string for varchar(N) 
automatically. Also smallint and tinyint could be converted into int.

Would be nice to have something similar in Impala.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to