[
https://issues.apache.org/jira/browse/HIVE-19262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V updated HIVE-19262:
---------------------------
Component/s: (was: Hive)
File Formats
> 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: File Formats
> Affects Versions: 0.13.1
> Reporter: liupengcheng
> Priority: Major
>
> 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)