[ 
https://issues.apache.org/jira/browse/CARBONDATA-625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15829374#comment-15829374
 ] 

Manish Gupta commented on CARBONDATA-625:
-----------------------------------------

This issue is fixed as part of PR-535 
(https://github.com/apache/incubator-carbondata/pull/535). This issue can be 
closed.

> Abnormal behaviour of Int datatype
> ----------------------------------
>
>                 Key: CARBONDATA-625
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-625
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-load
>    Affects Versions: 1.0.0-incubating
>         Environment: Spark: 1.6  and hadoop: 2.6.5 
>            Reporter: Geetika Gupta
>            Assignee: Manish Gupta
>            Priority: Minor
>         Attachments: Screenshot from 2017-01-11 18-36-24.png, 
> testMaxValueForBigInt.csv
>
>
> I was trying to create a table having int as a column and loaded data into 
> the table. Data loading was performed successfully but when I viewed the data 
> of the table, there was some wrong data present in the table. I was trying to 
> load BigInt data to an int column. All the data in int column is loaded with 
> the first value of the csv. Below are the details for the queries:
> create table xyz(a int, b string)stored by 'carbondata';
> Data load query:
> LOAD DATA INPATH 'hdfs://localhost:54311/testFiles/testMaxValueForBigInt.csv' 
> into table xyz OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','FILEHEADER'='a,b');
> select query:
> select * from xyz;
> PFA the screenshot of the output and the csv file.



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

Reply via email to