We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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
The text was updated successfully, but these errors were encountered:
Successfully merging a pull request may close this issue.
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
The text was updated successfully, but these errors were encountered: