湖仓构建 LAKEFORMATION-修改表信息:请求示例
时间:2025-04-21 15:56:22
请求示例
PUT https://{endpoint}/v1/{project_id}/instances/{instance_id}/catalogs/{catalog_name}/databases/{database_name}/tables/{table_name} { "alter_params" : { "CASCADE" : "TRUE" }, "table" : { "table_name" : "tbl08e39978e97b4266a7074fd92127e032", "table_format" : "HIVE", "table_type" : "EXTERNAL_TABLE", "owner" : "onebox", "owner_type" : "USER", "create_time" : "2023-05-31T02:06:58.000+00:00", "last_access_time" : "2023-05-31T02:06:58.000+00:00", "last_analyzed_time" : "2023-05-31T02:06:58.000+00:00", "partition_keys" : [ { "column_type" : "string", "column_name" : "column_prefix0", "comment" : "372f0f259ed049f5876050dcd13df630" }, { "column_type" : "string", "column_name" : "column_prefix1", "comment" : "6bb9dd73db49498d9aaabd343bfad689" } ], "retention" : 1000, "storage_descriptor" : { "columns" : [ { "column_type" : "string", "column_name" : "column_prefix0", "comment" : "4a4eca73554c4117b480fd73d8d6697b" }, { "column_type" : "string", "column_name" : "column_prefix1", "comment" : "5dc9df8676324e989440b0e6669d9338" }, { "column_type" : "string", "column_name" : "column_prefix2", "comment" : "b73c6fdb55594366bcd25c45ffbbee47" }, { "column_type" : "string", "column_name" : "column_prefix3", "comment" : "74fe507023414e2ba6137aaee059c3f9" }, { "column_type" : "string", "column_name" : "column_prefix4", "comment" : "4bd450c11ea24884875cd62e9d3e42dc" }, { "column_type" : "string", "column_name" : "column_prefix5", "comment" : "2457eea4a38e4ead8bbc065985279544" }, { "column_type" : "string", "column_name" : "column_prefix6", "comment" : "39b5869cea974e1488a47584acf4c313" }, { "column_type" : "string", "column_name" : "column_prefix7", "comment" : "90928727a6bb4c6ca2e3497ea9b31bf8" }, { "column_type" : "string", "column_name" : "column_prefix8", "comment" : "90d6544f85004c58a056891f7d00fbb2" }, { "column_type" : "string", "column_name" : "column_prefix9", "comment" : "8e993211dcad4adbacc360c9e5d0bbd9" } ], "location" : "obs://location/test/database/7b2fad385fd8434cbb8e759094a068cf", "compressed" : false, "input_format" : "9ea8ec4fc8dc4faaa8e5d1ed1e2db776", "output_format" : "ce56f7ea7a754a14a5c4525b296cc6f1", "number_of_buckets" : 0, "bucket_columns" : [ ], "sort_columns" : [ ], "serde_info" : { "name" : "f69aa43399ec498dbc42290d8e26ac6d", "serialization_library" : "fe216304f4f84411ba2d52b32688bfe6", "parameters" : { "f2d383124614470895a0ce2619bf3a32" : "69ee824ac98944d78f321af7a6edd538" } }, "parameters" : { "dbc72b6d947e4d6f9a4b5ec081ebd07a" : "e5f22c513e984e3cb279ba5e40a2f69a", "64eb05edecae4722befd2e3575d3cbe8" : "656c632c586940649fcc1a4e62c8c0a1" }, "skewed_info" : { "skewed_column_names" : [ ], "skewed_column_value_location_maps" : { }, "skewed_column_values" : [ ] }, "stored_as_sub_directories" : false }, "parameters" : { "key1" : "value1", "transient_lastDdlTime" : "120", "classification" : "other" }, "comments" : "comment info" } }
support.huaweicloud.com/api-lakeformation/UpdateTable.html