> 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
> Priority: Major
> 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.
>
>
>
Locked
