[
https://issues.apache.org/jira/browse/HIVE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated HIVE-3229:
-----------------------------
Description:
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;
was:
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.
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
