Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.incubator.apache.org
Date: Wed, 19 Oct 2016 04:33:59 +0000 (UTC)
From: "Harmeet Singh (JIRA)" <jira@apache.org>
To: issues@carbondata.incubator.apache.org
Message-ID: <JIRA.13013393.1476851206000.25143.1476851639657@Atlassian.JIRA>
In-Reply-To: <JIRA.13013393.1476851206000@Atlassian.JIRA>
References: <JIRA.13013393.1476851206000@Atlassian.JIRA> <JIRA.13013393.1476851206753@arcas>
Subject: [jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns
 contains Null, after load data
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 19 Oct 2016 04:34:04 -0000


     [ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Harmeet Singh updated CARBONDATA-324:
-------------------------------------
    Description: 
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. 


> 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
>
> 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)