Shulou(Shulou.com)05/31 Report--

This article mainly introduces how Hive can not use DDL, the article is very detailed, has a certain reference value, interested friends must read it!

Mysql version: 5.6.25

Hive version: 0.12

Just after installing and configuring hive, start the hive client, and enter show databases; to find the following error:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

Analyze the reasons:

At first, I thought there was some conflict in the version, but later I found that this was not the case. I opened MySQL and checked the database (show databases;). I found that the database configured in hive-site.xml was not created in MySQL. It was suspected that it was due to MySQL's lack of authorization, so I immediately used it:

> GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' 123' WITH GRANT OPTION

> FLUSH PRIVILEGES

After authorization, by remote login: mysql-h master.hadoop-u root-P 3306-p123, an error occurred:

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

Look at the information above and know that the password is correct, but you need to reset the password, so:

> SET PASSWORD = PASSWORD ('123')

Then re-perform the remote login and appear again:

ERROR 1045 (28000): Access denied for user 'root'@'hadoop.master' (using password: YES)

I don't know what the problem is, but I guess it is because of the security problem that I don't give GRANT ALL ON directly. Command, and finally execute the following command:

> SET PASSWORD FOR 'root'@'hadoop.master' = PASSWORD (' 123')

OK! The problem is solved. Start HIVE and enter SHOW DATABASES;. The result comes out.

The above is all the contents of the article "what to do if Hive can't use DDL". Thank you for reading! Hope to share the content to help you, more related 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.