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
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
