Chetan Bhat created CARBONDATA-4020: ---------------------------------------
Summary: Drop bloom index for single index of table having multiple index drops all indexes Key: CARBONDATA-4020 URL: https://issues.apache.org/jira/browse/CARBONDATA-4020 Project: CarbonData Issue Type: Bug Components: data-query Affects Versions: 2.1.0 Environment: Spark 2.4.5 Reporter: Chetan Bhat Create multiple bloom indexes on the table. Try to drop single bloom index drop table if exists datamap_test_1; CREATE TABLE datamap_test_1 (id int,name string,salary float,dob date)STORED as carbondata TBLPROPERTIES('SORT_COLUMNS'='id'); CREATE index dm_datamap_test_1_2 ON TABLE datamap_test_1(id) as 'bloomfilter' PROPERTIES ( 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true'); CREATE index dm_datamap_test3 ON TABLE datamap_test_1 (name) as 'bloomfilter' PROPERTIES ('BLOOM_SIZE'='640000', 'BLOOM_FPP'='0.00001', 'BLOOM_COMPRESS'='true'); show indexes on table datamap_test_1; drop index dm_datamap_test_1_2 on datamap_test_1; show indexes on table datamap_test_1; Issue : Drop bloom index for single index of table having multiple index drops all indexes 0: jdbc:hive2://linux-32:22550/> show indexes on table datamap_test_1; +----------------------+--------------+------------------+----------------------------------------------------+----------+-------- | Name | Provider | Indexed Columns | Properties | Status | Sync In +----------------------+--------------+------------------+----------------------------------------------------+----------+-------- | dm_datamap_test_1_2 | bloomfilter | id | 'INDEX_COLUMNS'='id','bloom_compress'='true','bloom_fpp'='0.00001','blo | dm_datamap_test3 | bloomfilter | name | 'INDEX_COLUMNS'='name','bloom_compress'='true','bloom_fpp'='0.00001','b +----------------------+--------------+------------------+----------------------------------------------------+----------+-------- 2 rows selected (0.315 seconds) 0: jdbc:hive2://linux-32:22550/> drop index dm_datamap_test_1_2 on datamap_test_1; +---------+ | Result | +---------+ +---------+ No rows selected (1.232 seconds) 0: jdbc:hive2://linux-32:22550/> show indexes on table datamap_test_1; +-------+-----------+------------------+-------------+---------+------------+ | Name | Provider | Indexed Columns | Properties | Status | Sync Info | +-------+-----------+------------------+-------------+---------+------------+ +-------+-----------+------------------+-------------+---------+------------+ No rows selected (0.21 seconds) 0: jdbc:hive2://linux-32:22550/> -- This message was sent by Atlassian Jira (v8.3.4#803005)