[
https://issues.apache.org/jira/browse/HIVE-25739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17450369#comment-17450369
]
xiepengjie commented on HIVE-25739:
-----------------------------------
Yeer，as you said. Maybe we are afraid of user adding large number of KVs. The
fact is that more and more companies use the hms as a unified metadata
management system， which means the stored data not only hive's table, but also
flink's table, or kafka's topic，etc. All of them need special parameters for
the partition. Now we set the partition's parameters through the following code:
{code:java}
HiveConf hiveConf = new HiveConf();
HiveMetaStoreClient hmsc = new HiveMetaStoreClient(hiveConf);
Partition partition = hmsc.getPartition("default", "test", "2021-11-29");
Map<String, String> parameters = partition.getParameters();
parameters.put("newKey", "newValue");
hmsc.alter_partition("db", "tableName", partition);{code}
so, i think our restriction is in vain，and support this feature is more useful.
> Support Alter Partition Properties
> ----------------------------------
>
> Key: HIVE-25739
> URL: https://issues.apache.org/jira/browse/HIVE-25739
> Project: Hive
> Issue Type: New Feature
> Affects Versions: All Versions
> Reporter: xiepengjie
> Assignee: xiepengjie
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.3.8
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Support alter partition properties like:{{{{}}{}}}
> {code:java}
> alter table alter1 partition(insertdate='2008-01-01') set tblproperties
> ('a'='1', 'c'='3');
> alter table alter1 partition(insertdate='2008-01-01') unset tblproperties if
> exists ('c'='3');{code}
>
> relates to https://issues.apache.org/jira/browse/HIVE-14261
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
