[ https://issues.apache.org/jira/browse/CARBONDATA-4066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajantha Bhat updated CARBONDATA-4066: ------------------------------------- Fix Version/s: (was: 2.2.0) 2.1.1 > data mismatch observed with SI and without SI when SI global sort and SI > segment merge is true > ---------------------------------------------------------------------------------------------- > > Key: CARBONDATA-4066 > URL: https://issues.apache.org/jira/browse/CARBONDATA-4066 > Project: CarbonData > Issue Type: Bug > Reporter: Mahesh Raju Somalaraju > Priority: Major > Fix For: 2.1.1 > > Time Spent: 50m > Remaining Estimate: 0h > > data mismatch observed with SI and without SI when SI global sort and SI > segment merge is true > > test case for reproduce the issue: > CarbonProperties.getInstance() > .addProperty(CarbonCommonConstants.CARBON_SI_SEGMENT_MERGE, "true") > sql("create table complextable2 (id int, name string, country array<string>) > stored as " + > "carbondata tblproperties('sort_scope'='global_sort','sort_columns'='name')") > sql( > s"load data inpath '$resourcesPath/secindex/array.csv' into table > complextable2 options('delimiter'=','," + > > "'quotechar'='\"','fileheader'='id,name,country','complex_delimiter_level_1'='$'," > + > "'global_sort_partitions'='10')") > val result = sql(" select * from complextable2 where > array_contains(country,'china')") > sql("create index index_2 on table complextable2(country) as 'carbondata' > properties" + > "('sort_scope'='global_sort')") > checkAnswer(sql("select count(*) from complextable2 where > array_contains(country,'china')"), > sql("select count(*) from complextable2 where > ni(array_contains(country,'china'))")) -- This message was sent by Atlassian Jira (v8.3.4#803005)