Member since
05-09-2018
5
Posts
0
Kudos Received
0
Solutions
05-09-2018
02:51 AM
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.
... View more
Labels:
- Labels:
-
Apache Hive