[ 
https://issues.apache.org/jira/browse/HIVE-11147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14609325#comment-14609325
 ] 

Wei Zheng commented on HIVE-11147:
----------------------------------

[~thejas] It seems there is incomplete coverage in the test class 
TestHiveMetaTool. This is a separate issue and I will follow up with another 
JIRA.

> 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)

Reply via email to