[
https://issues.apache.org/jira/browse/HIVE-11147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606897#comment-14606897
]
Thejas M Nair commented on HIVE-11147:
--------------------------------------
+1
> MetaTool doesn't update FS root location for partitions with space in name
> --------------------------------------------------------------------------
>
> Key: HIVE-11147
> URL: https://issues.apache.org/jira/browse/HIVE-11147
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Wei Zheng
> Assignee: Wei Zheng
> Attachments: HIVE-11147.01.patch
>
>
> Problem happens when trying to update the FS root location:
> {code}
> # HIVE_CONF_DIR=/etc/hive/conf.server/ hive --service metatool -dryRun
> -updateLocation hdfs://mycluster hdfs://c6401.ambari.apache.org:8020
> ...
> Looking for LOCATION_URI field in DBS table to update..
> Dry Run of updateLocation on table DBS..
> old location: hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse new
> location: hdfs://mycluster/apps/hive/warehouse
> Found 1 records in DBS table to update
> Looking for LOCATION field in SDS table to update..
> Dry Run of updateLocation on table SDS..
> old location:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/web_sales/ws_web_site_sk=12
> new location:
> hdfs://mycluster/apps/hive/warehouse/web_sales/ws_web_site_sk=12
> old location:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/web_sales/ws_web_site_sk=13
> new location:
> hdfs://mycluster/apps/hive/warehouse/web_sales/ws_web_site_sk=13
> ...
> Found 143 records in SDS table to update
> Warning: Found records with bad LOCATION in SDS table..
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=Advanced
> Degree
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=Advanced
> Degree
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=4
> yr Degree
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=4
> yr Degree
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=2
> yr Degree
> bad location URI:
> hdfs://c6401.ambari.apache.org:8020/apps/hive/warehouse/customer_demographics/cd_education_status=2
> yr Degree
> {code}
> The reason why some entries are marked as bad location is that they have
> space character in the partition name.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
