carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Himani Arora (JIRA)" <>
Subject [jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
Date Thu, 15 Dec 2016 08:13:58 GMT


Himani Arora updated CARBONDATA-324:
    Attachment: Screenshot from 2016-10-19 10-54-06.png

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:

The output was fine and as expected and so this seems no longer a bug to me.

> Decimal and Bigint type columns contains Null, after load data
> --------------------------------------------------------------
>                 Key: CARBONDATA-324
>                 URL:
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Harmeet Singh
>         Attachments: Screenshot from 2016-10-19 10-54-06.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

View raw message