You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by "Mohammad Shahid Khan (JIRA)" <ji...@apache.org> on 2016/07/18 10:53:20 UTC

[jira] [Created] (CARBONDATA-64) data mismatch between the carbon Table and Hive Table for data having empty lines

Mohammad Shahid Khan created CARBONDATA-64:
----------------------------------------------

             Summary: data mismatch between the carbon Table and Hive Table for data having empty lines
                 Key: CARBONDATA-64
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-64
             Project: CarbonData
          Issue Type: Bug
            Reporter: Mohammad Shahid Khan
            Assignee: Mohammad Shahid Khan


data mismatch between the carbon Table and Hive Table for data having empty lines

create table if not exists emptyRowCarbonTable (eid string,ename String,sal decimal,presal " +
        "decimal,comm decimal" +
        "(37,37),deptno decimal(18,2),Desc String) STORED BY 'org.apache.carbondata.format'

LOAD DATA INPATH '$csvFilePath' INTO table emptyRowCarbonTable OPTIONS('DELIMITER'=',','QUOTECHAR'='"','FILEHEADER'='eid,ename,sal,presal,comm,deptno,Desc')

1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
2,\N,\N,\N,\N,\N,\N

4,,d,,d,d,






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)