[
https://issues.apache.org/jira/browse/HIVE-29096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18009145#comment-18009145
]
Zhihua Deng commented on HIVE-29096:
------------------------------------
Init the tables from test.sql, then run the below command,
{noformat}
./bin/hive --service metatool -updateLocation hdfs://new.namenode2:8020/
hdfs://old.host -tablePropKey
avro.schema.url,metadata_location,previous_metadata_location -serdePropKey
avro.schema.url,metadata_location,dummy_serde_prop,input.regex{noformat}
check the db,
{noformat}
select * from TABLE_PARAMS where PARAM_KEY in
('avro.schema.url','metadata_location','previous_metadata_location');
select * from SERDE_PARAMS where PARAM_KEY in
('avro.schema.url','metadata_location','dummy_serde_prop','input.regex'){noformat}
The params are updated and replaced with the new prefix
hdfs://new.namenode2:8020/, means it works as expected.
> Enhance the metatool updateLocation for multiple table or serde properties
> --------------------------------------------------------------------------
>
> Key: HIVE-29096
> URL: https://issues.apache.org/jira/browse/HIVE-29096
> Project: Hive
> Issue Type: Improvement
> Reporter: Zhihua Deng
> Assignee: Zhihua Deng
> Priority: Major
> Labels: pull-request-available
> Attachments: test.sql
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
