[jira] [Resolved] (HIVE-3229) null values being loaded as non-null values into Hive

["Dudu Markovitz (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dudu Markovitz resolved HIVE-3229.
----------------------------------
    Resolution: Not A Bug

> null values being loaded as non-null values into Hive
> -----------------------------------------------------
>
>                 Key: HIVE-3229
>                 URL: https://issues.apache.org/jira/browse/HIVE-3229
>             Project: Hive
>          Issue Type: Bug
>            Reporter: N Campbell
>         Attachments: CERT.TSET1.txt
>
>
> various tab delimited input files contain one or more columns that represent null values in rows. the data appears to load (without an error such as in JIRA 3228) however the resulting values are now non-null values which is incorrect.
> create table if not exists CERT.TSET1_E ( RNUM int , C1 int, C2 string)
> row format delimited
> fields terminated by '\t'
> stored as textfile;
> create table if not exists CERT.TSET1 ( RNUM int , C1 int, C2 string)
> stored as sequencefile;
> load data local inpath '....CERT.TSET1.txt'
> overwrite into table CERT.TSET1_E;
> insert overwrite table CERT.TSET1  select * from CERT.TSET1_E;



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)