[jira] [Updated] (CARBONDATA-2892) Data mismatch is seen in the Array-String and Array-Timestamp.

["Prasanna Ravichandran (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CARBONDATA-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Prasanna Ravichandran updated CARBONDATA-2892:
----------------------------------------------
    Attachment: Array.csv

> 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.
>  
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)