You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Indhumathi Muthu Murugesh (Jira)" <ji...@apache.org> on 2020/12/02 08:46:00 UTC
[jira] [Resolved] (CARBONDATA-4020) Drop bloom index for single
index of table having multiple index drops all indexes
[ 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)