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 configuration
export JAVA_HOME="/usr/lib/jvm/java-9-oracle"
export PATH="$PATH:$JAVA_HOME/bin"

# Hadoop home directory configuration
export HADOOP_HOME=/usr/local/hadoop
export PATH=$PATH:$HADOOP_HOME/bin
export PATH=$PATH:$HADOOP_HOME/sbin

export HIVE_HOME=/usr/lib/hive
export 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

Related Posts:

  1. Error: NoClassDefFoundError: org/apache/commons/logging/LogFactory
  2. Hadoop “Unable to load native-hadoop library for your platform” warning
  3. Why is Fetch task in Hive works faster than Map-only task?
  4. HTTP Status 500 Error instantiating servlet class
  5. Hive: how to show all partitions of a table?
  6. fs.hdfs.impl.disable.cache caused SparkSQL very slow
  7. Hive dynamic partitioning
  8. Difference between hive.tez.container.size and tez.task.resource.memory.mb
  9. Difference between `load data inpath ` and `location` in hive?
  10. how to write subquery and use “In” Clause in Hive
  11. Where can I download the jar for org.apache.http package?
  12. How to format strings in Java
  13. What exactly is Apache Camel?
  14. What is an instance variable in Java?
  15. How does the Java ‘for each’ loop work?
  16. How does the Java ‘for each’ loop work?
  17. What does “Could not find or load main class” mean?
  18. How do I create a file and write to it?
  19. How can I use pointers in Java?
  20. How do I generate random integers within a specific range in Java?
  21. “Exception in thread “main” java.lang.IndexOutOfBoundsException: Index: 0, Size: 0″ with ArrayList?
  22. Raising a number to a power in Java
  23. How do I limit the number of decimals printed for a double?
  24. Unfortunately MyApp has stopped. How can I solve this?
  25. exception in thread ‘main’ java.lang.NoClassDefFoundError:
  26. java.io.FileNotFoundException: the system cannot find the file specified
  27. How to parse this string in Java?
  28. How to match “any character” in regular expression?
  29. Double array initialization in Java
  30. Explain the use of a bit vector for determining if all characters are unique
  31. Convert java.util.Date to String
  32. How do I do a deep copy of a 2d array in Java?
  33. Returning an empty array
  34. Java Security: Illegal key size or default parameters?
  35. Could not reserve enough space for object heap
  36. Eclipse: Java was started but returned error code=13
  37. Why java unknown: import org.apache.commons.codec.binary.Base64;?
  38. Extracting .jar file with command line
  39. Unable to create requested service [org.hibernate .engine.jdbc.env.spi.JdbcEnvironment]-MySQL
  40. JRE 1.7 – java version – returns: java/lang/NoClassDefFoundError: java/lang/Object
  41. Good Java graph algorithm library?
  42. Integrate Ant builder into Eclipse: Error “Variable references empty selection”
  43. Spring Maven clean error – The requested profile “pom.xml” could not be activated because it does not exist
  44. Java Class File Editor
  45. Error Importing SSL certificate : Not an X.509 Certificate
  46. How do I draw a triangle?
  47. Installing jdk8 on ubuntu- “unable to locate package” update doesn’t fix
  48. Java – Access is denied java.io.FileNotFoundException
  49. Static Block in Java
  50. What does Scanner input = new Scanner(System.in) actually mean?
  51. Class ‘Room’ is abstract; cannot be instantiated
  52. Creating a maze solving algorithm in Java
  53. What is HTTPD exactly?
  54. IDEA: javac: source release 1.7 requires target release 1.7
  55. Can we write our own iterator in Java?
  56. Why am i getting ” Duplicate modifier for the type Test” and how to fix it
  57. Picked up _JAVA_OPTIONS: -Xmx256M
  58. When to use static methods
  59. How to serialize an object into a string
  60. Getting the array length of a 2D array in Java
  61. Java String to SHA1
  62. How do I call one constructor from another in Java?
  63. Does Java have something like C#’s ref and out keywords?
  64. How to upload a file and JSON data in Postman?
  65. What is the difference between i++ & ++i in a for loop?
  66. when to throw FileNotFoundException
  67. Connection reset by peer: mod_fcgid: error reading data from FastCGI server
  68. JAVA_HOME is set to an invalid directory:
  69. How to Set the Background Color of a JButton on the Mac OS
  70. How to easily convert a BufferedReader to a String?
  71. How can I calculate a time difference in Java?
  72. Detecting a long press with Android
  73. How to increase the size of an array in Java?
  74. Cannot invoke toString() on the primitive type int
  75. How to fix the error; ‘Error: Bootstrap tooltips require Tether (http://github.hubspot.com/tether/)’
  76. How fix Error:java.util.concurrent.ExecutionException: com.android.ide.common.process.ProcessException:
  77. Is it okay to throw NullPointerException programmatically?
  78. Android: how to create Switch case from this?
  79. Read next word in java
  80. Convert float to double without losing precision
  81. Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space
  82. How do the post increment (i++) and pre increment (++i) operators work in Java?
  83. Manually throw an exception
  84. Spring boot: Unable to start embedded Tomcat servlet container
  85. How does paintComponent work?
  86. What happens when wp_cron is deactivated in WordPress?
  87. Rewrite /?rest_route=/ link to /wp-json/ without changing default permalink structure in apache
  88. Media sizes aren’t being created – server config?
  89. WordPress multisite causing Error 101 (net::ERR_CONNECTION_RESET): Unknown error [duplicate]
  90. Is it possible to move wordpress out of webroot?
  91. Rule to redirect non logged in User to Custom Registration/login Page in .htaccess file
  92. .htaccess file missing from WordPress install directory
  93. Multisite gives Error if i want to enter Dashboard or Site
  94. Page preview is shown, updating page gives 404 error
  95. How to redirect specific URL to Subdomain
  96. Recommendation for server config for WordPress Staging servers [closed]
  97. issue with wordpress [wp-admin] redirects, when using kubernetes ingress hosting two wordpress websites using path
  98. Admin-area broken through weird issues
  99. Can’t get pretty permalinks to work without index.php
  100. How To Add CSP frame ancestors in WordPress Website? [closed]

Leave a Comment