You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "liupengcheng (JIRA)" <ji...@apache.org> on 2018/04/21 09:20:00 UTC

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

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)