SHOW DELETE
Description
This statement is used to display the historical delete tasks that have been successfully executed
Syntax
SHOW DELETE [FROM <db_name>]
Optional Parameters
<db_name> : The name of the database to be displayed
Return Value
Column | Description |
---|---|
TableName | The name of the table where the delete operation was executed. |
PartitionName | The name of the partition affected by the delete operation. |
CreateTime | The timestamp when the delete operation was issued. |
DeleteCondition | The condition used for the delete operation, specifying which rows were deleted. |
State | The status of the delete operation |
Example
-
Go to the test database to view all historical delete tasks
show delete;
+---------------+---------------+---------------------+-----------------+----------+
| TableName | PartitionName | CreateTime | DeleteCondition | State |
+---------------+---------------+---------------------+-----------------+----------+
| iceberg_table | * | 2025-03-14 15:53:32 | id EQ "1" | FINISHED |
+---------------+---------------+---------------------+-----------------+----------+ -
Display all historical delete tasks of database database
show delete from tpch;
+-----------+---------------+---------------------+-------------------+----------+
| TableName | PartitionName | CreateTime | DeleteCondition | State |
+-----------+---------------+---------------------+-------------------+----------+
| customer | * | 2025-03-14 15:45:19 | c_custkey EQ "18" | FINISHED |
+-----------+---------------+---------------------+-------------------+----------+