Chang Zhichao created HIVE-25644:
------------------------------------
Summary: 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
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.3.4#803005)
