SHOW_FS_PATH_DETAIL
This topic is available for MRS 3.3.0 or later only.
Function
Checks statistics about a specified FS path.
Syntax
call show_fs_path_detail(path=>'[path]', is_sub=>'[is_sub]', sort=>'[sort]');
Parameters
| Parameter | Description | Mandatory |
|---|---|---|
| path | Path of the FS to be queried | Yes |
| is_sub | The default value is false, indicating that statistics about a specified directory is collected. The value true indicates that statistics about subdirectories in a specified directory is collected. | No |
| sort | The default value is true, indicating that the results are sorted based on storage_size. The value false indicates that the results are sorted based on the number of files. | No |
Example
call show_fs_path_detail(path=>'/user/hive/warehouse/hudi_mor/dt=2021-08-28', is_sub=>false, sort=>true);
Returned Result
| Parameter | Description |
|---|---|
| path_num | Number of subdirectories in a specified directory |
| file_num | Number of files in a specified directory |
| storage_size | Size of the directory, in bytes |
| storage_size(unit) | Size of the directory, in KB |
| storage_path | Complete FS absolute path of the specified directory |
| space_consumed | Actual space occupied by the returned files/directories in the cluster, that is, the replication factor set for the cluster is considered. |
| quota | Name quota, which is a mandatory restriction on the number of files and directory names in the current directory tree |
| space_quota | Space quota, which is a mandatory restriction on the number of bytes used by files in the current directory tree |
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.