Help Center/ Data Lake Insight/ Hudi SQL Syntax Reference/ DLI Hudi SQL Syntax Reference/ Hudi DDL Syntax/ TRUNCATE TABLE
Updated on 2025-04-21 GMT+08:00
View PDF

TRUNCATE TABLE

Function

This command is used to clear all data in a specific table.

Syntax

TRUNCATE TABLE tableIdentifier

Parameter Description

Table 1 Parameter descriptions

Parameter

Description

tableIdentifier

Table name.

Example

truncate table h0_1;

System Response

Data in the table is cleared. You can run the QUERY statement to check whether data in the table has been deleted.

Parent topic: Hudi DDL Syntax