CreatePartition
Adds a partition to a data table in the data lake.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
dlf:CreatePartition |
create |
*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 HTTP 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 the partition information. If this parameter is set to true, the Partition parameter is returned in the response. |
true |
| PartitionInput | PartitionInput |
No |
The input information for the partition. |
|
| 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 description of the status code. |
OK |
| Message |
string |
The response message. |
. |
| Partition | Partition |
The partition result. This parameter is returned when NeedResult is set to true. |
|
| RequestId |
string |
The ID of the request. |
B7F4B621-E41E-4C84-B97F-42B5380A32BB |
| Success |
boolean |
Indicates whether the call was successful. Valid values:
|
true |
Error code descriptions for Code:
-
InvalidObject: The specified database or table is not found.
-
AlreadyExists: The specified partition already exists.
-
InternalError: An error of another type occurred. Refer to the Message parameter for details.
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.