CREATE TABLE example_table (id UInt32, data String) ENGINE=MergeTree() ORDER BY id;ALTER TABLE example_table MODIFY SETTING max_part_loading_threads=8, max_parts_in_total=50000;
RESET SETTING
将表设置重置为默认值。如果某项设置已处于默认状态,则不会执行任何操作。语法
RESET SETTING setting_name [, ...]
示例
CREATE TABLE example_table (id UInt32, data String) ENGINE=MergeTree() ORDER BY id SETTINGS max_part_loading_threads=8;ALTER TABLE example_table RESET SETTING max_part_loading_threads;