Hive数据仓库问题:SemanticException Unable to determine if hdfs
hive> select * from users;
报错信息:
FAILED: SemanticException Unable to determine if hdfs://mycluster/user/hive/warehouse/hive.db/users is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://mycluster/user/hive/warehouse/hive.db/users, expected: hdfs://s101:8020
出错原因:
一般是hive的数据存储路径不对,具体到底是什么原因,还需要进一步深究
解决方案:
到mysql中修改执行如下命令:
mysql>update DBS setDB_LOCATION_URI=REPLACE (DB_LOCATION_URI,'mycluster','s101');
mysql> update SDS setLOCATION=REPLACE (LOCATION,'mycluster','s101');
修改之后,进入hive中进行查看