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

SHOW_COMMIT_FILES

Function

Checks whether multiple files are updated in or inserted to a specified instant.

Syntax

call show_commit_files(table=>'[table]', instant_time=>'[instant_time]', limit=>[limit]);

Parameter Description

Table 1 Parameter descriptions

Parameter

Description

Mandatory

table

Name of the table to be queried. The value can be in the database.tablename format.

Yes

instant_time

Timestamp corresponding to a commit operation

Yes

limit

Number of returned items

No

Example

call show_commit_files(table=>'hudi_mor', instant_time=>'20230216144548249');
call show_commit_files(table=>'hudi_mor', instant_time=>'20230216144548249', limit=>1);

Returned Result

Parameter

Description

action

Action type of the commit operation corresponding to instant_time, such as compaction, deltacommit, and clean

partition_path

Partition where the file updated in or inserted to a specified instant is located

file_id

ID of the file updated in or inserted to the specified instant

previous_commit

Timestamp in the file name of the file updated in or inserted to the specified instant

total_records_updated

Number of updated records in the file

total_records_written

Number of records inserted into the file

total_bytes_written

Number of bytes of data added to the file

total_errors

Total number of errors reported during the update in or insertion to the specified instant

file_size

File size, in bytes

Permission Requirements

Metadata service provided by DLI

  • SQL permissions:

    database

    table

    None

    SELECT
  • Fine-grained permission: dli:table:select

Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.

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