java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

I did below modifications and I am able to start the Hive Shell without any errors:

1. ~/.bashrc

Inside bashrc file add the below environment variables at End Of File : sudo gedit ~/.bashrc

#Java Home directory configurationexport JAVA_HOME="/usr/lib/jvm/java-9-oracle"export PATH="$PATH:$JAVA_HOME/bin"# Hadoop home directory configurationexport HADOOP_HOME=/usr/local/hadoopexport PATH=$PATH:$HADOOP_HOME/binexport PATH=$PATH:$HADOOP_HOME/sbinexport HIVE_HOME=/usr/lib/hiveexport PATH=$PATH:$HIVE_HOME/bin

2. hive-site.xml

You have to create this file(hive-site.xml) in conf directory of Hive and add the below details

<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet type="text/xsl" href="configuration.xsl"?><configuration><property>  <name>javax.jdo.option.ConnectionURL</name>  <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value></property><property>  <name>javax.jdo.option.ConnectionDriverName</name>  <value>com.mysql.jdbc.Driver</value></property><property>  <name>javax.jdo.option.ConnectionUserName</name>  <value>root</value></property><property>  <name>javax.jdo.option.ConnectionPassword</name>  <value>root</value></property><property>  <name>datanucleus.autoCreateSchema</name>  <value>true</value></property><property>  <name>datanucleus.fixedDatastore</name>  <value>true</value></property><property> <name>datanucleus.autoCreateTables</name> <value>True</value> </property></configuration>

3. You also need to put the jar file(mysql-connector-java-5.1.28.jar) in the lib directory of Hive

4. Below installations required on your Ubuntu to Start the Hive Shell:

1. MySql
2. Hadoop
3. Hive
4. Java

5. Execution Part:

1. Start all services of Hadoop: start-all.sh

2. Enter the jps command to check whether all Hadoop services are up and running: jps

3. Enter the hive command to enter into hive shell: hive

starting the hive metastore service worked for me.First, set up the database for hive metastore:

 $ hive --service metastore 

`https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/validate_installation.html

Second, run the following commands:

 $ schematool -dbType mysql -initSchema   $ schematool -dbType mysql -info

https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool

If you're just playing around in local mode, you can drop metastore DB and reinstate it:

rm -rf metastore_db/$HIVE_HOME/bin/schematool -initSchema -dbType derby