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

[Akash R Nilugal (Jira)]

Geetika Gupta created CARBONDATA-625:
----------------------------------------

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