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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-4020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Indhumathi Muthu Murugesh resolved CARBONDATA-4020.
---------------------------------------------------
    Fix Version/s: 2.2.0
       Resolution: Fixed

> 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
>            Priority: Minor
>             Fix For: 2.2.0
>
>          Time Spent: 5h 40m
>  Remaining Estimate: 0h
>
> 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)