Truncate Table

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See TRUNCATE TABLE.

TRUNCATE TABLE table_name [PARTITION part_spec]

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.

PARTITION

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.