错误信息
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to determine if hdfs://master01.cdh:8020/user/hive/warehouse/acccore.db/t_sy_banks is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://master01.cdh:8020/user/hive/warehouse/acccore.db/t_sy_banks, expected: hdfs://nameservice1
解决方案
Hive元数据的问题,在Hive数据库中有两张表:
DBS : Hive数据仓库的总路径
SDS : Hive每张表对应的路径
step1: 进入hive metastore 所在的mysql
step2. use metastore;
step3. 修改dbs 和 sds表
update DBS set DB_LOCATION_URI=REPLACE (DB_LOCATION_URI,'master01.cdh:8020','nameservice1');
update SDS set LOCATION=REPLACE (LOCATION,'master01.cdh:8020','nameservice1');