Help Center/ Data Lake Insight/ SQL Syntax Reference (Ally Region)/ Spark SQL Syntax Reference/ Clearing Data
Updated on 2026-01-09 GMT+08:00
View PDF
Share

Clearing Data

Function

This statement is used to delete data from DLI or OBS tables.

Syntax

1
 
TRUNCATE TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)];

Keywords

Table 1 Keywords

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.

Precautions

Only data in DLI or OBS tables can be deleted.

Example

1
 
truncate table test PARTITION (class = 'test');
Parent Topic: Spark SQL Syntax Reference