Clearing Data
Function
This statement is used to delete data from the DLI or OBS table.
Syntax
1
|
TRUNCATE TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)]; |
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 the DLI or OBS table can be deleted.
Example
1
|
truncate table test PARTITION (class = 'test'); |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot