[
https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750738#comment-15750738
]
Himani Arora edited comment on CARBONDATA-324 at 12/15/16 8:20 AM:
-------------------------------------------------------------------
This seems no longer a bug to me.
I did the following steps:
create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by
'carbondata';
LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test
options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data');
test1.csv contains the following fields:
himani,1,900000,292092
The output was fine and as expected:
!https://issues.apache.org/jira/secure/attachment/12843371/CARBONDATA-324.png!
was (Author: himani1):
This seems no longer a bug to me.
I did the following steps:
create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by
'carbondata';
LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test
options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data');
test1.csv contains the following fields:
himani,1,900000,292092
The output was fine and as expected
> Decimal and Bigint type columns contains Null, after load data
> --------------------------------------------------------------
>
> Key: CARBONDATA-324
> URL: https://issues.apache.org/jira/browse/CARBONDATA-324
> Project: CarbonData
> Issue Type: Bug
> Reporter: Harmeet Singh
> Attachments: CARBONDATA-324.png
>
>
> Using Thrift server and Beeling client, i am trying to create a table and
> load the data from CSV. My tables contains BigInt and Decimal Column types,
> After load the data using Load Data command, The BigInt and Decimal Column
> contains Null Value. Bellow are the steps:
> Step 1:
> > create database wednesday;
> > use wednesday;
> > CREATE TABLE one (id int, age iNt, name String, salary decimal, data
> > bigInt, weight double, dob timeStamp) STORED BY 'carbondata';
> Step 2:
> Create a csv file which contains column values as below:
> id, age, name, salary, data, weight, dob
> 1, 54, james, 900000, 292092, 34.2, 2016-05-04 22:55:00
> Step 3:
> Load the data from CSV file as below:
> > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO
> > TABLE one;
> Step 4:
> Select the data from table one, and BigInt and Decimal column contains Null
> value.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
