[CARBONDATA-4020] Drop bloom index for single index of table having multiple index drops all indexes

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.1
• Component/s: data-query
• Environment: Spark 2.4.5
• Assignee: Unassigned
• Reporter: Chetan Bhat
• Created: 01/Oct/20 09:20
• Updated: 17/Mar/21 03:06
• Resolved: 02/Dec/20 08:45

Description

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/>