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

Posted by Akash R Nilugal (Jira) on Mar 17, 2021; 3:07am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Updated-CARBONDATA-4020-Drop-bloom-index-for-single-index-of-table-having-multiple-index-drops-s-tp106901.html


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

Ajantha Bhat updated CARBONDATA-4020:
-------------------------------------
    Fix Version/s:     (was: 2.2.0)
                   2.1.1

> 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.1.1
>
>          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)