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)
