Adds a partition to a data table in a data lake.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
dlf:CreatePartition |
*All Resource
|
None | None |
Request syntax
POST /api/metastore/catalogs/databases/tables/partitions HTTP/1.1
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| Body |
object |
No |
The request body in JSON format. |
|
| CatalogId |
string |
No |
The ID of the data catalog. |
1344371 |
| DatabaseName |
string |
No |
The name of the database. |
database_test |
| IfNotExists |
boolean |
No |
Specifies whether to ignore the exception if a partition with the same name already exists. |
true |
| NeedResult |
boolean |
No |
Specifies whether to return partition information. If you set this parameter to true, the Partition object is returned. |
true |
| PartitionInput | PartitionInput |
No |
The partition input. |
|
| TableName |
string |
No |
The name of the data table. |
test_table_20201223 |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response body. |
||
| Code |
string |
The status code. |
OK |
| Message |
string |
The returned message. |
. |
| Partition | Partition |
The partition details. This parameter is returned only when NeedResult is set to true. |
|
| RequestId |
string |
The request ID. |
B7F4B621-E41E-4C84-B97F-42B5380A32BB |
| Success |
boolean |
Indicates whether the call was successful. Valid values:
|
true |
Error codes:
-
InvalidObject: The specified database or table cannot be found.
-
AlreadyExists: The specified partition already exists.
-
InternalError: An internal error occurred. For more information, see the value of the Message parameter.
Examples
Success response
JSON format
{
"Code": "OK",
"Message": ".",
"Partition": {
"CreateTime": 1608730999,
"DatabaseName": "database_test",
"LastAccessTime": 1608730999,
"LastAnalyzedTime": 1608730999,
"Parameters": {
"key": "key"
},
"Privileges": {
"GroupPrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
},
"RolePrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
},
"UserPrivileges": {
"key": [
{
"CreateTime": 1606226844,
"GrantOption": true,
"Grantor": "Grantor",
"GrantorType": "GrantorType",
"Privilege": "Privilege"
}
]
}
},
"Sd": {
"BucketCols": [
"2010"
],
"Cols": [
{
"Comment": "comment_day",
"Name": "day",
"Parameters": {
"key": "key"
},
"Type": "int"
}
],
"Compressed": false,
"InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
"Location": "file:///tmp/table",
"NumBuckets": 10,
"OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
"Parameters": {
"key": "key"
},
"SerDeInfo": {
"Name": "name",
"Parameters": {
"key": "key"
},
"SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
},
"SkewedInfo": {
"SkewedColNames": [
"col1"
],
"SkewedColValueLocationMaps": {
"key": "{“col1”:\"val1\"}"
},
"SkewedColValues": [
[
"\"123\""
]
]
},
"SortCols": [
{
"Col": "col1",
"Order": 1
}
],
"StoredAsSubDirectories": false
},
"TableName": "test_table_20201223",
"Values": [
"part1"
]
},
"RequestId": "B7F4B621-E41E-4C84-B97F-42B5380A32BB",
"Success": true
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.