05-09-2018 02:51 AM
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.