Just followed the tutorial on Tutorials point for installing Hive, I am running Ubuntu 15.04, with Hadoop 2.6.0 and attempting to install Hive 1.2.1 with Derby 10.11.1.1 The full error when executing:
hive
is
Exception in thread "main" java.lang.RuntimeException:
java.lang.RuntimeException: unable to instantiate
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at
org.apache.hadoop.hive.ql.Session.SessionState.start(SessionState.java:522)
Any Assistance with this would be greatly appreciated.
May be it could be due to more than one metastore_db.
1. Remove "metastore_db".It should be under $HIVE_HOME/bin/metastore_db.
You can locate it using "locate metastore_db"
$ rm metastore_db/*.lck
2. Then restart hadoop cluster and the run hive from hive shell again.
See if it works or not.
Edit
The JDBC DriverManager can't find any suitable Driver for the given connection URL. Either the JDBC driver isn't loaded at all before connecting the DB, or the connection URL is wrong. Check the derby.jar in ur hive/lib path. is it derbyclient.jar or derby.jar. Also check $HIVE_HOME/conf/hive-site.xml file for matching driver/connection url path