[
https://issues.apache.org/jira/browse/HIVE-25644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chang Zhichao updated HIVE-25644:
---------------------------------
Priority: Major (was: Critical)
> Hive complex types column query result error when "create table as select"
> --------------------------------------------------------------------------
>
> Key: HIVE-25644
> URL: https://issues.apache.org/jira/browse/HIVE-25644
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.1.2
> Reporter: Chang Zhichao
> Priority: Major
>
> When "*create table as select*" ** query contains *map<string, array<int>>*
> type column, the column in new table is null.
>
> This is a demo to reproduce the bug:
> {code:java}
> hive> CREATE TABLE struct_table(info map<string, array<int>>);
> hive> insert into struct_table values (map('test', array(1,2)));
> hive> select * from struct_table;
> OK
> {"test":[1,2]}
> Time taken: 0.245 seconds, Fetched: 1 row(s)
> hive> create table struct_table_bak as select * from struct_table;
> hive> select * from struct_table_bak;
> OK
> {"test":null}
> Time taken: 0.102 seconds, Fetched: 1 row(s)
> {code}
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
