clickhouse：SYSTEM STOP MERGES does not work

Asked Apr 01 '21 at 02:09

Active Apr 01 '21 at 05:06

Viewed 1,006 times

In factally，I want to use SYSTEM STOP MERGES TABLE to stop merge and then migrate some parts to another shard. My operation as follow:

clickhouse-client -q "insert into DTDB.lineorder_demo FORMAT CSV" < lineorder.tbl；

SYSTEM STOP MERGES DTDB.lineorder_demo

immediately after the import is complete. But within 15 minutes, the parts will still merge and decrease.

edited Apr 01 '21 at 05:06

vladimir

asked Apr 01 '21 at 02:09

Bubble Li

1

Because `stop merges` is not applicable to Distributed Engine – Denny Crane Apr 01 '21 at 12:43
@DennyCrane It s has nothing to do with Distributed Engine, old_parts_lifetime causes expired parts to be deleted after 8 minutes. – Bubble Li Oct 29 '21 at 06:56

0 Answers0