Obtains the analysis results of multiple Hive databases at a time.
Debugging
Authorization information
The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:
- Operation: the value that you can use in the Action element to specify the operation on a resource.
- Access level: the access level of each operation. The levels are read, write, and list.
- Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
- The required resource types are displayed in bold characters.
- If the permissions cannot be granted at the resource level,
All Resourcesis used in the Resource type column of the operation.
- Condition Key: the condition key that is defined by the cloud service.
- Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.
| Operation | Access level | Resource type | Condition key | Associated operation |
|---|---|---|---|---|
| emr:ListDoctorHiveDatabases | list | *All Resources * |
| none |
Request parameters
| Parameter | Type | Required | Description | Example |
|---|---|---|---|---|
| RegionId | string | Yes | The region ID. | cn-hangzhou |
| ClusterId | string | Yes | The cluster ID. | c-b933c5aac8fe**** |
| NextToken | string | No | The pagination token that is used in the request to retrieve a new page of results. | DD6B1B2A-5837-5237-ABE4-FF0C89568980 |
| MaxResults | integer | No | The maximum number of entries to return on each page. | 20 |
| DateTime | string | Yes | The query date. | 2023-01-01 |
| DatabaseNames | array | No | The database names. | |
| String | string | No | The database name. | db1 |
| OrderType | string | No | The order in which you want to sort the query results. Valid values:
| ASC |
| OrderBy | string | No | The basis on which you want to sort the query results. Valid values:
| tableCount |
Response parameters
Examples
Sample success responses
JSONformat
{
"Data": [
{
"DatabaseName": "db1",
"Formats": [
{
"FormatName": "TextInputFormat",
"FormatSize": 1000,
"FormatSizeUnit": "MB",
"FormatRatio": 0.5,
"FormatDayGrowthSize": 1000,
"FormatSizeDayGrowthRatio": 0.5
}
],
"Metrics": {
"TableCount": {
"Name": "TableCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of tables\n"
},
"PartitionNum": {
"Name": "ppartitionNum",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of partitions\n"
},
"LargeFileCount": {
"Name": "largeFileCount",
"Value": 1000,
"Unit": "“”",
"Description": "Number of large files\n"
},
"MediumFileCount": {
"Name": "mediumFileCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of medium files\n"
},
"SmallFileCount": {
"Name": "smallFileCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of small files\n"
},
"TinyFileCount": {
"Name": "tinyFileCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of tiny files\n"
},
"EmptyFileCount": {
"Name": "emptyFileCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of empty files\n"
},
"TotalFileCount": {
"Name": "totalFileCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Number of total files\n"
},
"LargeFileRatio": {
"Name": "largeFileRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of large files\n"
},
"MediumFileRatio": {
"Name": "mediumFileRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of medium files\n"
},
"SmallFileRatio": {
"Name": "smallFileRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of small files\n"
},
"TinyFileRatio": {
"Name": "tinyFileRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of tiny files\n"
},
"EmptyFileRatio": {
"Name": "emptyFileRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of empty files\n"
},
"HotDataSize": {
"Name": "hotDataSize",
"Value": 1000,
"Unit": "MB",
"Description": "Ratio of hot files\n"
},
"WarmDataSize": {
"Name": "warmDataSize",
"Value": 1000,
"Unit": "MB",
"Description": "Ratio of warm files\n"
},
"ColdDataSize": {
"Name": "coldDataSize",
"Value": 1000,
"Unit": "MB",
"Description": "Ratio of cold files\n"
},
"FreezeDataSize": {
"Name": "freezeDataSize\t",
"Value": 1000,
"Unit": "MB",
"Description": "Ratio of freeze files\n"
},
"TotalDataSize": {
"Name": "totalDataSize",
"Value": 1000,
"Unit": "MB",
"Description": "Total data size in megabytes (MB)\n"
},
"HotDataRatio": {
"Name": "hotDataRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Hot data ratio\n"
},
"WarmDataRatio": {
"Name": "warmDataRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of warm data\n"
},
"ColdDataRatio": {
"Name": "coldDataRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Cold data ratio\n"
},
"FreezeDataRatio": {
"Name": "freezeDataRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Ratio of freeze data\n"
},
"TotalFileDayGrowthCount": {
"Name": "totalFileDayGrowthCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of total files\n"
},
"LargeFileDayGrowthCount": {
"Name": "largeFileDayGrowthCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of large files\n"
},
"MediumFileDayGrowthCount": {
"Name": "mediumFileDayGrowthCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of medium files\n"
},
"SmallFileDayGrowthCount": {
"Name": "smallFileDayGrowthCount\t",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of small files\n"
},
"TinyFileDayGrowthCount": {
"Name": "tinyFileDayGrowthCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of tiny files\n"
},
"EmptyFileDayGrowthCount": {
"Name": "emptyFileDayGrowthCount",
"Value": 1000,
"Unit": "\"\"",
"Description": "Day growth count of empty files\n"
},
"HotDataDayGrowthSize": {
"Name": "hotDataDayGrowthSize\t",
"Value": 1000,
"Unit": "MB",
"Description": "Day growth size of hot data\n"
},
"WarmDataDayGrowthSize": {
"Name": "warmDataDayGrowthSize\t",
"Value": 1000,
"Unit": "MB",
"Description": "Day growth size of warm data\n"
},
"ColdDataDayGrowthSize": {
"Name": "coldDataDayGrowthSize",
"Value": 1000,
"Unit": "MB",
"Description": "Day growth size of cold data\n"
},
"FreezeDataDayGrowthSize": {
"Name": "freezeDataDayGrowthSize\t",
"Value": 1000,
"Unit": "MB",
"Description": "Day growth size of freeze data\n"
},
"TotalDataDayGrowthSize": {
"Name": "totalDataDayGrowthSize",
"Value": 1000,
"Unit": "MB",
"Description": "Day growth size of total data\n"
},
"TotalFileCountDayGrowthRatio": {
"Name": "totalFileCountDayGrowthRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of total files\n"
},
"LargeFileCountDayGrowthRatio": {
"Name": "largeFileCountDayGrowthRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of large files\n"
},
"MediumFileCountDayGrowthRatio": {
"Name": "mediumFileCountDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of medium files\n"
},
"SmallFileCountDayGrowthRatio": {
"Name": "smallFileCountDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of small files\n"
},
"TinyFileCountDayGrowthRatio": {
"Name": "tinyFileCountDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of tiny files\n"
},
"EmptyFileCountDayGrowthRatio": {
"Name": "emptyFileCountDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of empty files\n"
},
"HotDataSizeDayGrowthRatio": {
"Name": "hotDataSizeDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of hot data size\n"
},
"WarmDataSizeDayGrowthRatio": {
"Name": "WarmDataSizeDayGrowthRatio",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of warm data size\n"
},
"ColdDataSizeDayGrowthRatio": {
"Name": "coldDataSizeDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of cold data size\n"
},
"FreezeDataSizeDayGrowthRatio": {
"Name": "freezeDataSizeDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of freeze data size\n"
},
"TotalDataSizeDayGrowthRatio": {
"Name": "totalDataSizeDayGrowthRatio\t",
"Value": 0.5,
"Unit": "\"\"",
"Description": "Day growth ratio of total data size\n"
}
},
"Analysis": {
"HiveFrequencyScore": 85,
"HiveDistributionScore": 85,
"HiveFormatScore": 85,
"HiveScore": 85
}
}
],
"RequestId": "DD6B1B2A-5837-5237-ABE4-FF0C8944****",
"NextToken": "DD6B1B2A-5837-5237-ABE4-FF0C89568980",
"MaxResults": 20,
"TotalCount": 200
}Error codes
| HTTP status code | Error code | Error message |
|---|---|---|
| 400 | ConflictParameters | Parameters that must not be used together. %s |
| 400 | IncompleteSignature | The request signature is invalid. |
| 400 | InvalidAction | The action %s requested is invalid. |
| 400 | InvalidParameter | The specified parameter %s is not valid. |
| 400 | InvalidParameterValue | The input parameter %s is invalid or out of range. |
| 400 | MissingAction | The action %s requested is missing. |
| 400 | MissingParameter | The input parameter %s that is mandatory for processing this request is not supplied. |
| 400 | NotAuthorized | You do not have permission to perform this action. %s |
| 400 | ThrottlingException | The request was denied due to request throttling. %s |
| 404 | ResourceNotFound | The resource not found by %s. |
| 500 | InternalError | The request processing has failed due to some unknown error, exception or failure. |
| 503 | ServiceFailure | The request has failed due to a temporary failure of %s service. |
| 503 | ServiceUnavailable | The request has failed due to a temporary failure of the server. |
For a list of error codes, visit the Service error codes.
Change history
| Change time | Summary of changes | Operation |
|---|
No change history