hive select报错 Unable to determine if hdfs

hive报错信息：

FAILED: SemanticException Unable to determine if hdfs://nameservice1/user/hive/warehouse/peacebird.db/st_pause_store_item is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://nameservice1/user/hive/warehouse/peacebird.db/st_pause_store_item, expected: hdfs://zt01:8020

这种情况一般是hive的数据存储路径不对，直接去mysql里修改hive的原数据就可以：

mysql执行如下命令：

use hive;

update DBS set DB_LOCATION_URI=REPLACE (DB_LOCATION_URI,'nameservice1','zt01')

update SDS set LOCATION=REPLACE (LOCATION,'nameservice1','zt01');