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

ROLL_BACK

Function

Rolls back a specified commit.

Syntax

call rollback_to_instant(table => '[table_name]', instant_time => '[instant]');

Parameter Description

Table 1 Parameter descriptions

Parameter

Description

table_name

Mandatory. Name of the Hudi table to be rolled back.

instant

Mandatory. Commit instant timestamp of the Hudi table to be rolled back.

Example

call rollback_to_instant(table => 'h1', instant_time=>'20220915113127525');

Caveats

  • You can only roll back the latest commit timestamp sequentially. You can check the latest instant time using the SHOW_TIME_LINE command.

System Response

You can check if the job status is successful, view the job result, and review the job logs to confirm if there are any exceptions.

Parent topic: Hudi CALL COMMAND Syntax