Truncate Table


This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See TRUNCATE TABLE.

TRUNCATE TABLE table_name [PARTITION part_spec]

  : (part_col1=value1, part_col2=value2, ...)

Delete all rows from a table or matching partitions in the table. The table must not be an external table or a view.


A partial partition spec to match partitions to be truncated. In Spark 2.0, this is supported only for tables created using the Hive format. Since Spark 2.1, data source tables are also supported. Not supported for Delta tables.