SHOW_LOG_FILE
This topic is available for MRS 3.3.0 or later only.
Function
This command is used to view the meta and record information in log files.
Syntax
- Checking meta information:
call show_logfile_metadata(table => '[table]', log_file_path_pattern => '[log_file_path_pattern]', limit => '[limit]')
- Checking record information:
call show_logfile_records(table => '[table]', log_file_path_pattern => '[log_file_path_pattern]', merge => '[merge]', limit => '[limit]')
Parameters
| Parameter | Description | Mandatory |
|---|---|---|
| table | Name of the table to be queried. The value can be in the database.tablename format. | Yes |
| log_file_path_pattern | Path of log files. Regular expression matching is supported. | No |
| merge | When show_logfile_records is executed, this parameter is used to specify whether to combine records in multiple log files and return them together. | No |
| limit | Number of returned items | No |
Example
call show_logfile_metadata(table => 'hudi_mor', log_file_path_pattern => 'http://hacluster/user/hive/warehouse/hudi_mor/dt=2021-08-28/.*?log.*?'); call show_logfile_records(table => 'hudi_mor', log_file_path_pattern => 'http://hacluster/user/hive/warehouse/hudi_mor/dt=2021-08-28/.*?log.*?', merge => false, limit => 1);
Constraints
- This command is used only for MOR tables.
Response
You can view query results on the client.
