ADMIN COMPACT

Description

  1. This statement is used to trigger compaction for all replicas of a specified partition
  3. Grammar:
  5. ADMIN COMPACT TABLE table_name PARTITION partition_name WHERE TYPE='BASE/CUMULATIVE'
  7. Explain:
  9. 1. This statement only means that the system attempts to submit a compaction task for each replica under the specified partition to compaction thread pool, and it is not guaranteed to be successful.
  10. 2. This statement supports executing compaction task for a single partition of the table at a time.

example

  1. 1. Attempt to trigger cumulative compaction for all replicas under the specified partition
  3. ADMIN COMPACT TABLE tbl PARTITION par01 WHERE TYPE='CUMULATIVE';
  5. 2. Attempt to trigger base compaction for all replicas under the specified partition
  7. ADMIN COMPACT TABLE tbl PARTITION par01 WHERE TYPE='BASE';

keyword

  1. ADMIN,COMPACT