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

[Akash R Nilugal (Jira)]

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)