UpdateColumnStatisticsForTable
Creates or updates table statistics of columns.
The Identity and Access Management (IAM) permission required for this operation is UpdateTable.
Request Syntax
{
"CatalogId": "string",
"ColumnStatisticsList": [
{
"AnalyzedTime": number,
"ColumnName": "string",
"ColumnType": "string",
"StatisticsData": {
"BinaryColumnStatisticsData": {
"AverageLength": number,
"MaximumLength": number,
"NumberOfNulls": number
},
"BooleanColumnStatisticsData": {
"NumberOfFalses": number,
"NumberOfNulls": number,
"NumberOfTrues": number
},
"DateColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"DecimalColumnStatisticsData": {
"MaximumValue": {
"Scale": number,
"UnscaledValue": blob
},
"MinimumValue": {
"Scale": number,
"UnscaledValue": blob
},
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"DoubleColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"LongColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"StringColumnStatisticsData": {
"AverageLength": number,
"MaximumLength": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"Type": "string"
}
}
],
"DatabaseName": "string",
"TableName": "string"
}Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
The request accepts the following data in JSON format.
- CatalogId
-
The ID of the Data Catalog where the partitions in question reside. If none is supplied, the AWS account ID is used by default.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*Required: No
- ColumnStatisticsList
-
A list of the column statistics.
Type: Array of ColumnStatistics objects
Array Members: Minimum number of 0 items. Maximum number of 25 items.
Required: Yes
- DatabaseName
-
The name of the catalog database where the partitions reside.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*Required: Yes
- TableName
-
The name of the partitions' table.
Type: String
Length Constraints: Minimum length of 1. Maximum length of 255.
Pattern:
[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*Required: Yes
Response Syntax
{
"Errors": [
{
"ColumnStatistics": {
"AnalyzedTime": number,
"ColumnName": "string",
"ColumnType": "string",
"StatisticsData": {
"BinaryColumnStatisticsData": {
"AverageLength": number,
"MaximumLength": number,
"NumberOfNulls": number
},
"BooleanColumnStatisticsData": {
"NumberOfFalses": number,
"NumberOfNulls": number,
"NumberOfTrues": number
},
"DateColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"DecimalColumnStatisticsData": {
"MaximumValue": {
"Scale": number,
"UnscaledValue": blob
},
"MinimumValue": {
"Scale": number,
"UnscaledValue": blob
},
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"DoubleColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"LongColumnStatisticsData": {
"MaximumValue": number,
"MinimumValue": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"StringColumnStatisticsData": {
"AverageLength": number,
"MaximumLength": number,
"NumberOfDistinctValues": number,
"NumberOfNulls": number
},
"Type": "string"
}
},
"Error": {
"ErrorCode": "string",
"ErrorMessage": "string"
}
}
]
}Response Elements
If the action is successful, the service sends back an HTTP 200 response.
The following data is returned in JSON format by the service.
- Errors
-
List of ColumnStatisticsErrors.
Type: Array of ColumnStatisticsError objects
Errors
For information about the errors that are common to all actions, see Common Errors.
- EntityNotFoundException
-
A specified entity does not exist
HTTP Status Code: 400
- GlueEncryptionException
-
An encryption operation failed.
HTTP Status Code: 400
- InternalServiceException
-
An internal service error occurred.
HTTP Status Code: 500
- InvalidInputException
-
The input provided was not valid.
HTTP Status Code: 400
- OperationTimeoutException
-
The operation timed out.
HTTP Status Code: 400
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
