[jira] [Updated] (HIVE-19262) empty array will be saved as NULL by insert into select

["Gopal V (JIRA)" <ji...@apache.org>]

     [ 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)