liupengcheng created HIVE-19262:
-----------------------------------
Summary: empty array will be saved as NULL by insert into select
Key: HIVE-19262
URL: https://issues.apache.org/jira/browse/HIVE-19262
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 0.13.1
Reporter: liupengcheng
Data is generated by MR parquet, and the data contains empty list.
When executing the following sql, the emtpy list col of the result is different
from the original data.
`insert into table a as select * from b `
{code:java}
>select col1 from a where size(col1) = 0 limit 1;
[] // will show []
>insert into table b select col1 from a;
>select col1 from b;
NULL // will show NULL
{code}
I was wondering if we should return the same result as before, and should not
change the data saved.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
