Updated on 2024-10-09 GMT+08:00

SHOW_COMMIT_FILES

This topic is available for MRS 3.3.0 or later only.

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]');

Parameters

Table 1 Parameter description

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 updated or inserted by 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

Response

You can view query results on the client.