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);