[jira] [Commented] (CARBONDATA-625) Abnormal behaviour of Int datatype

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (CARBONDATA-625) Abnormal behaviour of Int datatype

Akash R Nilugal (Jira)

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