【Hive】报错 FAILED: SemanticException Unable to determine if hdfs://

最新推荐文章于 2024-11-14 10:09:54 发布

Simple_Zz

最新推荐文章于 2024-11-14 10:09:54 发布

阅读量3.5k

点赞数 1

分类专栏：错误集锦文章标签： Hive hadoop 大数据

本文链接：https://blog.csdn.net/love284969214/article/details/82975448

版权

Logging initialized using configuration in file:/soft/softwares/apache-hive-1.2.1-bin/conf/hive-log4j.properties
FAILED: SemanticException Unable to determine if
hdfs://localhost:8020/user/hive/warehouse/student is encrypted: 
java.lang.IllegalArgumentException: Wrong FS: 
hdfs://localhost:8020/user/hive/warehouse/student, expected: hdfs://192.168.25.121:8020

此错误原因：

mysql 中 DBS 与 SDS 两表中设置了 Hive的元数据信息需要修改此表。

mysql> use metastore;
mysql> select * from DBS;
mysql> select LOCATION from SDS; 


+-------+-----------------------+-------------------------------------------+---------+------------+------------+
| DB_ID | DESC                  | DB_LOCATION_URI                           | NAME    | OWNER_NAME | OWNER_TYPE |
+-------+-----------------------+-----------------------------