Open qidaye opened 5 days ago
master
When drop a column which has bloom filter, the column is dropped, but the bloom filter info are not dropped.
Drop column and the bloom filter is dropped too.
mysql> create table table1 ( -> k1 INT, -> c1 varchar(10), -> ) duplicate key(k1) distributed by hash(k1) buckets 1 -> properties( -> "replication_num" = "1", -> "bloom_filter_columns" = "c1" -> ); Query OK, 0 rows affected (0.01 sec) mysql> mysql> alter table table1 drop column c1; Query OK, 0 rows affected (0.01 sec) mysql> show create table table1; +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | table1 | CREATE TABLE `table1` ( `k1` int NULL ) ENGINE=OLAP DUPLICATE KEY(`k1`) DISTRIBUTED BY HASH(`k1`) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "min_load_replica_num" = "-1", "bloom_filter_columns" = "", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "binlog.enable" = "false", "binlog.ttl_seconds" = "86400", "binlog.max_bytes" = "9223372036854775807", "binlog.max_history_nums" = "9223372036854775807", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728" ); | +--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
No response
Search before asking
Version
master
What's Wrong?
When drop a column which has bloom filter, the column is dropped, but the bloom filter info are not dropped.
What You Expected?
Drop column and the bloom filter is dropped too.
How to Reproduce?
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct