[ https://issues.apache.org/jira/browse/CARBONDATA-4143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Indhumathi Muthu Murugesh resolved CARBONDATA-4143. --------------------------------------------------- Fix Version/s: 2.2.0 Resolution: Fixed > UT with index server > -------------------- > > Key: CARBONDATA-4143 > URL: https://issues.apache.org/jira/browse/CARBONDATA-4143 > Project: CarbonData > Issue Type: Improvement > Reporter: SHREELEKHYA GAMPA > Priority: Major > Fix For: 2.2.0 > > Time Spent: 8h 50m > Remaining Estimate: 0h > > To enable to run UT with index server using flagĀ {{useIndexServer.}} > excluded some of the test cases to not run with index server. > To Fix below issues: > 1. With index server enabled, select query gives incorrect result with SI > when parent and child table segments are not in sync. > queries to execute: > 0: jdbc:hive2://dggphisprb50622:22550/> create table test (c1 string,c2 > int,c3 string,c5 string) STORED AS carbondata; > +---------+ > |Result| > +---------+ > +---------+ > No rows selected (0.564 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> load data inpath > 'hdfs://hacluster/chetan/dest.csv' into table test; > +-------------+ > |Segment ID| > +-------------+ > |0| > +-------------+ > 1 row selected (1.764 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> create index index_test on table > test (c3) AS 'carbondata'; > +---------+ > |Result| > +---------+ > +---------+ > No rows selected (2.412 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> load data inpath > 'hdfs://hacluster/chetan/dest.csv' into table test; > +-------------+ > |Segment ID| > +-------------+ > |1| > +-------------+ > 1 row selected (2.839 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> select * from test where c3='dd'; > +------+----++-----------+ > |c1|c2|c3|c5| > +------+----++-----------+ > |d|4|dd|ddd| > |d|4|dd|ddd| > +------+----++-----------+ > 2 rows selected (3.452 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> delete from table index_test where > segment.ID in(1); > +---------+ > |Result| > +---------+ > +---------+ > No rows selected (0.413 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> select * from test where c3='dd'; > +------+----++-----------+ > |c1|c2|c3|c5| > +------+----++-----------+ > |d|4|dd|ddd| > +------+----++-----------+ > 1 row selected (3.262 seconds) > 0: jdbc:hive2://dggphisprb50622:22550/> > Expected: to return 2 rows. > 2. When reindex is triggered, if stale files are present in the segment > directory the segment file is being written with incorrect file names. (both > valid index and stale mergeindex file names). As a result, duplicate data is > present in SI table but there is no error/incorrect query results. -- This message was sent by Atlassian Jira (v8.3.4#803005)