TRUNCATE TABLE

Syntax

• Clear the data of a table.

  TRUNCATE TABLE db_name.table_name;               

• Clear the data of specified partitions in a table.

  TRUNCATE TABLE db_name.table_name PARTITION partition_name;               

  The data type of partition names is BIGINT. You can execute the following SQL statement to obtain the names of all partitions in a table:

  select partition_name from information_schema.partitions where table_name = 'your_table_name' order by partition_name desc limit 100;               

Precautions

When you execute the TRUNCATE TABLE statement to clear the data of a table, the table schema is not deleted.

Example

• Clear the data of the customer table.

  TRUNCATE TABLE adb_demo.customer;                   

• Clear the data of specified partitions in the customer table.

  TRUNCATE TABLE adb_demo.customer partition 20170103,20170104,20170108;