You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Thejas M Nair (JIRA)" <ji...@apache.org> on 2015/06/30 04:55:04 UTC
[jira] [Commented] (HIVE-11147) MetaTool doesn't update FS root
location for partitions with space in name
[ 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)