New Contributor
Posts: 1
Registered: ‎05-09-2018

FAILED: SemanticException while executing queries in hive shell



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.

Cloudera Employee
Posts: 573
Registered: ‎03-23-2015

Re: FAILED: SemanticException while executing queries in hive shell

Your HiveMetaStore server is not up and running probably.

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