Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the

FAILED: SemanticException while executing queries in hive shell

FAILED: SemanticException while executing queries in hive shell

New Contributor

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

Re: FAILED: SemanticException while executing queries in hive shell

Guru
Your HiveMetaStore server is not up and running probably.

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