Prasanna Ravichandran created CARBONDATA-2892:
-------------------------------------------------
Summary: Data mismatch is seen in the Array-String and
Array-Timestamp.
Key: CARBONDATA-2892
URL: https://issues.apache.org/jira/browse/CARBONDATA-2892
Project: CarbonData
Issue Type: Bug
Environment: 3 Node ANT.
Reporter: Prasanna Ravichandran
Attachments: Array.csv
Data mismatch is seen in the Array-String and Array-Timestamp like mismatch in
data, order, date values.
*Test queries:*
drop table if exists array_com_hive;
create table array_com_hive (CUST_ID string, YEAR int, MONTH int, AGE int,
GENDER string, EDUCATED string, IS_MARRIED string, ARRAY_INT
array<int>,ARRAY_STRING array<string>,ARRAY_DATE array<string>,CARD_COUNT
int,DEBIT_COUNT int, CREDIT_COUNT int, DEPOSIT double, HQ_DEPOSIT double) row
format delimited fields terminated by ',' collection items terminated by '$';
load data local inpath '/opt/csv/complex/Array.csv' into table array_com_hive;
drop table if exists array_com;
create table Array_com (CUST_ID string, YEAR int, MONTH int, AGE int, GENDER
string, EDUCATED string, IS_MARRIED string, ARRAY_INT array<int>,ARRAY_STRING
array<string>,ARRAY_DATE array<timestamp>,CARD_COUNT int,DEBIT_COUNT int,
CREDIT_COUNT int, DEPOSIT double, HQ_DEPOSIT double) using carbon;
insert into Array_com select * from array_com_hive;
select * from array_com_hive order by CUST_ID ASC limit 3;
select * from array_com order by CUST_ID ASC limit 3;
*Expected result:*
There should be no data mismatch and data in table should be same as it is in
CSV file.
*Actual result:*
Data mismatch is seen.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
