Shulou(Shulou.com)06/01 Report--

Editor to share with you after the configuration of HDFS HA hive throw wrong Wrong FS how to do, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Question:

In CDH5.x or Apache environment, when HA of NameNode is configured, Hive does not query data normally.

The following exception occurs in the Hive query:

FAILED: SemanticException Unable to determine if hdfs://hadoop-01:8020/user/hive/warehouse/t1

Is encrypted: java.lang.IllegalArgumentException: Wrong FS: hdfs://hadoop-01:8020/user/hive/warehouse/t1, expected: hdfs://nameservice1

two。 Resolve:

The problem with Hive metadata, there are two tables in the Hive database:

DBS: the total path of the Hive data warehouse

SDS: Hive the path corresponding to each table

a. Enter mysql

B.use hive

c. Modify dbs and sds tables

Update DBS set DB_LOCATION_URI=REPLACE (DB_LOCATION_URI,'hadoop-01:8020','nameservice1')

Update SDS set LOCATION=REPLACE (LOCATION,'hadoop-01:8020','nameservice1')

The above is all the contents of the article "what to do if hive throws the wrong Wrong FS after configuring HDFS HA". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.