[ https://issues.apache.org/jira/browse/CARBONDATA-665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
SWATI RAO updated CARBONDATA-665: --------------------------------- Request participants: (was: ) Priority: Minor (was: Major) > Comparision Failure occurs when we execute the same query in hive and > Carbondata > -------------------------------------------------------------------------------- > > Key: CARBONDATA-665 > URL: https://issues.apache.org/jira/browse/CARBONDATA-665 > Project: CarbonData > Issue Type: Bug > Affects Versions: 1.0.0-incubating > Environment: Spark 1.6 > Reporter: SWATI RAO > Priority: Minor > Attachments: Test_Data1.csv > > > Orderby is not working , so records are not coming in sequence as well there > is data difference and some values being stored as null > Data itself is stored incorrectly and is different from Hive > Spark version :1.6.2 > Create 1 query : create table Test_Boundary (c1_int int,c2_Bigint > Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string > string,c6_Timestamp Timestamp,c7_Datatype_Desc string) STORED BY > 'org.apache.carbondata.format' > Load 1 Query : LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/Test_Data1.csv' INTO > table Test_Boundary > OPTIONS('DELIMITER'=',','QUOTECHAR'='','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='') > Create 2 query : create table Test_Boundary1 (c1_int int,c2_Bigint > Bigint,c3_Decimal Decimal(38,30),c4_double double,c5_string > string,c6_Timestamp Timestamp,c7_Datatype_Desc string) STORED BY > 'org.apache.carbondata.format' > Load 2 query: LOAD DATA INPATH 'HDFS_URL/BabuStore/Data/Test_Data1.csv' INTO > table Test_Boundary1 > OPTIONS('DELIMITER'=',','QUOTECHAR'='','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='') > Select Query : > select > c1_int,c2_Bigint,c3_Decimal,c4_double,c5_string,c6_Timestamp,c7_Datatype_Desc > from Test_Boundary where c2_bigint=c2_bigint -- This message was sent by Atlassian JIRA (v6.3.15#6346)