Skip to main content

Truncate

Use this statement to clear data from a specified table and its partitions.

Syntax

TRUNCATE TABLE [db.]tbl [PARTITION(p1, p2, ...)];
  • This statement clears the data but retains the table or partition structure.

  • Unlike DELETE, TRUNCATE only performs metadata operations, making it faster and not affecting query performance.

  • Data removed by this operation cannot be recovered.

  • The table status must be NORMAL, and there should be no ongoing SCHEMA CHANGE operations.

  • This command may cause ongoing import tasks to fail.

Examples

1. Clear the table tbl in the example_db database

TRUNCATE TABLE example_db.tbl;

2. Clear the p1 and p2 partitions of the table tbl

TRUNCATE TABLE tbl PARTITION(p1, p2);