SHOW_COMMIT_FILES
Notes and Constraints
This section applies only to MRS 3.3.0-LTS or later.
Function
This command is used to check the number of files updated or inserted during a specific 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.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot