FAILED: SemanticException while executing queries in hive shell

[#1]

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.

[#2]

Your HiveMetaStore server is not up and running probably.

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