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

Reply via email to