Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Clearing Data
View PDF

Clearing Data

Function

Delete data from the DLI table.

Syntax

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

Keyword

Table 1 Parameter

Parameter

Description

tablename

Name of the target DLI table that runs the Truncate statement.

partcol1

Partition name of the DLI table to be deleted.

Precautions

Only data in the DLI table can be deleted.

Example

1
 
truncate table test PARTITION (class = 'test');
Parent topic: SQL Syntax of Batch Jobs