This statement is used to delete data from the DLI or OBS table.
1 | TRUNCATE TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)]; |
Parameter |
Description |
|---|---|
tablename |
Name of the target DLI or OBS table that runs the Truncate statement. |
partcol1 |
Partition name of the DLI or OBS table to be deleted. |
Only data in the DLI or OBS table can be deleted.
1 | truncate table test PARTITION (class = 'test'); |