[jira] [Updated] (CARBONDATA-2892) Data mismatch is seen in the Array-String and Array-Timestamp.
[ https://issues.apache.org/jira/browse/CARBONDATA-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasanna Ravichandran updated CARBONDATA-2892: -- Attachment: (was: 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,ARRAY_STRING array,ARRAY_DATE array,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,ARRAY_STRING > array,ARRAY_DATE array,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)
[jira] [Updated] (CARBONDATA-2892) Data mismatch is seen in the Array-String and Array-Timestamp.
[ 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,ARRAY_STRING array,ARRAY_DATE array,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,ARRAY_STRING > array,ARRAY_DATE array,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)
