Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

FAILED: SemanticException while executing queries in hive shell

avatar
Explorer

Hi,

 

I have installed Hadoop 3.0.0 and Hive 2.3.1 in my PC.

Parallely i installed mysql and working with sql commands in sql shell mode and working fine.

 

But While executing queries in Hive shell mode, i am receiving the following error,

 

hive> create table saurzcode(id int, name string);

FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

I configured the hive-site.xml properly and i created the hiveuser on the metastore database in mysql shell. And i granted privileges for that user and exected schemas. But while executing any queries in hive shell i am getting exception. Please let me know the solution for this exception.

1 REPLY 1

avatar
Super Guru
Your HiveMetaStore server is not up and running probably.

You need to check the HMS server log to see what's happening.