hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3229) null values being loaded as non-null values into Hive
Date Thu, 05 Jul 2012 11:56:34 GMT

     [ 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

        

Mime
View raw message