湖仓构建 LAKEFORMATION-批量修改分区信息:请求示例

时间:2024-04-08 11:19:40

请求示例

POST https://{endpoint}/v1/{project_id}/instances/{instance_id}/catalogs/{catalog_name}/databases/{database_name}/tables/{table_name}/partitions/batch-alter

{
  "partition_inputs" : [ {
    "partition" : {
      "partition_values" : [ "48e1f86dc4394a218b832d94411805fe", "5a2ab07a663c49a98cc606e6ffa0b178" ],
      "create_time" : "2023-05-30T09:06:41.000+00:00",
      "last_access_time" : "2023-05-30T09:06:41.000+00:00",
      "parameters" : {
        "key1" : "value1",
        "transient_lastDdlTime" : "120",
        "classification" : "other"
      },
      "storage_descriptor" : {
        "columns" : [ {
          "column_type" : "string",
          "column_name" : "column_prefix0",
          "comment" : "83e99b4daff04e75b28263bf44495a3c"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix1",
          "comment" : "d947669d90884014b60264b2770849ae"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix2",
          "comment" : "21edd8e92f2448deb036f8e4682ec694"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix3",
          "comment" : "fc25f38e8b694aebb34a2f84ef4a62f7"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix4",
          "comment" : "3443079e616d447f8f35da2014754701"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix5",
          "comment" : "5f7dda02ac8e4813b3eb4858abb7c520"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix6",
          "comment" : "2a6ae2e5bc3f4add99133106f2cd526c"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix7",
          "comment" : "84d50424269a41fbb5528b350e9d0b13"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix8",
          "comment" : "e3f1d2fa80454554a22e8564ec9c4832"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix9",
          "comment" : "f11315794e6d40daa2cb8347c61e5a46"
        } ],
        "location" : "obs://location/test/database/b593fc09871e4c9886ed931a3e51f9e5",
        "compressed" : false,
        "input_format" : "8c470072d43344a3a3bfabd2c7f9d6ec",
        "output_format" : "74ee5be43fb548e7b988390df05134fa",
        "number_of_buckets" : 0,
        "bucket_columns" : [ ],
        "sort_columns" : [ ],
        "serde_info" : {
          "name" : "9b3ea84748854c2d86a71ae37e246293",
          "serialization_library" : "e9632ffbbfbe425d8eac91e765e046e1",
          "parameters" : {
            "e5ae426044054a5f8e362b9b5729dbab" : "33d8296203f94760b1e4b7db55edce0d"
          }
        },
        "parameters" : {
          "7e27b28f439e40bea098dd65bc857334" : "ab893cac08bb4374beb8ff00a02e9a73",
          "c698760d6de74d0c92eee65bea283215" : "8ba9a058a5cc4ebaac6f43c9771e167a"
        },
        "skewed_info" : {
          "skewed_column_names" : [ ],
          "skewed_column_value_location_maps" : { },
          "skewed_column_values" : [ ]
        },
        "stored_as_sub_directories" : false
      }
    },
    "partition_values" : [ "48e1f86dc4394a218b832d94411805fe", "5a2ab07a663c49a98cc606e6ffa0b178" ]
  }, {
    "partition" : {
      "partition_values" : [ "e4af64d55308403a9abf1999afbbe2be", "079f4cd2ee5b4de6922ef8f0c92c82ae" ],
      "create_time" : "2023-05-30T09:06:41.000+00:00",
      "last_access_time" : "2023-05-30T09:06:41.000+00:00",
      "parameters" : {
        "key1" : "value1",
        "transient_lastDdlTime" : "120",
        "classification" : "other"
      },
      "storage_descriptor" : {
        "columns" : [ {
          "column_type" : "string",
          "column_name" : "column_prefix0",
          "comment" : "b40e5a6b6b3c4a538c4b7daa8bc49300"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix1",
          "comment" : "d7de59704feb4218ad6c3899f16f72e3"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix2",
          "comment" : "215d3961dd0c4858b884e50157da1d4b"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix3",
          "comment" : "b8e4888680ca449492be2344a81aba1d"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix4",
          "comment" : "1ac15b288c354834830062e48b04e3c8"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix5",
          "comment" : "5e65189b3f28434c8b96a56fb19b3005"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix6",
          "comment" : "7944cf9158514a96905712d686bc7c18"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix7",
          "comment" : "c6b9396476e541e9ab34a8eb5fda9953"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix8",
          "comment" : "978fe9b8a1d1437391e83553ae361bfc"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix9",
          "comment" : "4f7ed315c7c44c5683500104464f4776"
        } ],
        "location" : "obs://location/test/database/3971910eb87a41ee9d7096d538232c33",
        "compressed" : false,
        "input_format" : "620befc9b9a447fb95ecfb0d33fb636c",
        "output_format" : "fc943b36eaec4d1da525734e56374d32",
        "number_of_buckets" : 0,
        "bucket_columns" : [ ],
        "sort_columns" : [ ],
        "serde_info" : {
          "name" : "9286f98baef44841883166345635faed",
          "serialization_library" : "ac9cdbe5004d468798bc57b4ed10f602",
          "parameters" : {
            "cef1b8d74bdd43459793b00b4deff6ae" : "e66acd0f816047ae9e00d01a4045c340"
          }
        },
        "parameters" : {
          "0546e622cf2042598ed4f31e0b3b3276" : "be46b5accfdc41ba93f50fbe16b782c2",
          "a5b63ea213ab48be8c3c361fe93f75d2" : "c0f1215c944040cfad2e69fbe7cb4b0b"
        },
        "skewed_info" : {
          "skewed_column_names" : [ ],
          "skewed_column_value_location_maps" : { },
          "skewed_column_values" : [ ]
        },
        "stored_as_sub_directories" : false
      }
    },
    "partition_values" : [ "e4af64d55308403a9abf1999afbbe2be", "079f4cd2ee5b4de6922ef8f0c92c82ae" ]
  }, {
    "partition" : {
      "partition_values" : [ "e5ade865888a4bb0a22b71505dd0989d", "788dfdb29db342f488a6155a55875f5b" ],
      "create_time" : "2023-05-30T09:06:41.000+00:00",
      "last_access_time" : "2023-05-30T09:06:41.000+00:00",
      "parameters" : {
        "key1" : "value1",
        "transient_lastDdlTime" : "120",
        "classification" : "other"
      },
      "storage_descriptor" : {
        "columns" : [ {
          "column_type" : "string",
          "column_name" : "column_prefix0",
          "comment" : "a4398b0a8f404ad1a2d8d350efdcd812"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix1",
          "comment" : "c2d17faf55de41ddb9f098a684dd8473"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix2",
          "comment" : "5f2de67835ff49aba7b661712ef059a6"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix3",
          "comment" : "26ce9cc09f3545df80181cbed87d4da2"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix4",
          "comment" : "f5b65b8db66349b3a1f8eace0ea33334"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix5",
          "comment" : "3f9b100dbc2f45d58d6fbcfa63e0d806"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix6",
          "comment" : "22c5f279e9d04cada8bdee6ddbd38af7"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix7",
          "comment" : "7ac1468020094057bf2e1e41f3e035b8"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix8",
          "comment" : "8c8178e2fe694ace80e78d5c985f7165"
        }, {
          "column_type" : "string",
          "column_name" : "column_prefix9",
          "comment" : "3f8d23d533fe44b295067de73a8f1b68"
        } ],
        "location" : "obs://location/test/database/8c351a1aca6b426a936be4453da30c35",
        "compressed" : false,
        "input_format" : "9fb9f9d02b3044febe447a1ad4ca5297",
        "output_format" : "ba8acae75da24d858ebe99f4ef2fce84",
        "number_of_buckets" : 0,
        "bucket_columns" : [ ],
        "sort_columns" : [ ],
        "serde_info" : {
          "name" : "6e4b2479321842d191f1b540b348a4f1",
          "serialization_library" : "22209422df114f589b4ec28d19d86e52",
          "parameters" : {
            "a5c4f39d83d047748dcd1218764c7a1c" : "9e2256acd089474ba469d329d35ace13"
          }
        },
        "parameters" : {
          "997ebfa4c6e343789a92d20f7961c865" : "2a1899624e084fb4b26595469cd23f32",
          "86887611dd7345c88f3de16538cb3587" : "ac4aab973d50429d9803cb418c9d44e1"
        },
        "skewed_info" : {
          "skewed_column_names" : [ ],
          "skewed_column_value_location_maps" : { },
          "skewed_column_values" : [ ]
        },
        "stored_as_sub_directories" : false
      }
    },
    "partition_values" : [ "e5ade865888a4bb0a22b71505dd0989d", "788dfdb29db342f488a6155a55875f5b" ]
  } ]
}
support.huaweicloud.com/api-lakeformation/BatchUpdatePartition.html