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