menu
  • Register

Unable to instantiate org.apache.hadoop.hive.ql.metadata.sessionhivemetastoreclient

1 vote
192 views

Problem :

Currently I am using Hadoop 2.7.1 and apache-hive-1.2.1 versions installed on my ubuntu 14.0.

1. Why below error is occurring ?

2. Do I need to do metastore installation ?

3. When we are typing the hive command on terminal how the xml's internally getting called and what is the flow of the xml's?

4. Do I need to do any other configuration's ?

When I am trying to write the hive command on my ubuntu 14.0 terminal it is throwing the following exception to me :

$ hive
Logging initialized using configuration in jar:file:/usr/local/hive/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
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:530)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:680)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:630)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:70)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:52)
at java.lang.reflect.Method.invoke(Method.java:530)
at org.apache.hadoop.util.RunJar.run(RunJar.java:230)
at org.apache.hadoop.util.RunJar.main(RunJar.java:145)
Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1725)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:92)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:144)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:112)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3300)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3210)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:545)
... 8 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:73)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:56)
at java.lang.reflect.Constructor.newInstance(Constructor.java:431)
at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1541)
... 14 more
Caused by: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
NestedThrowables:
java.lang.reflect.InvocationTargetException

Provided my environment variables in ~/.bashrc file; Still the above error persist

#HIVE home directory configuration
export HIVE_HOME=/usr/local/hive/apache-hive-1.2.1-bin
export PATH="$PATH:$HIVE_HOME/bin"
●6 ●5 ●3
7,540 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

If you are just wondering around in just local mode then you can drop metastore DB and reinstate it as follows :

rm -rf metastore_db/

$HIVE_HOME/bin/schematool -initSchema -dbType derby

 

●9 ●7 ●4
38,600 points

Related questions

0 votes
1 answer 2 views
2 views
Failed: execution error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.teztask .
Problem: What caused the error, " failed: execution error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.teztask " ?
asked 1 day ago salim1 34.8k points
0 votes
1 answer 43 views
43 views
Which of the following command can be used to show partitions?
Problem: I am new to programming. I have a table with 1000+ partitions. The "Show partitions" command only lists a very small number of partitions I have found out that "show partitions" command only lists exactly the 500 partitions. And the "select ... where ..." command only processes the 500 partitions! So please guide me in showing all partitions.
asked Aug 7, 2020 Raphael Pacheco 4.9k points
1 vote
1 answer 15 views
15 views
Hadoop Warning: unable to load native-hadoop library for your platform
Problem : I am new in java. I'm running Hadoop 2.2.0. I'm tring configuring hadoop on a server running CentOs. When I run start-dfs.sh or stop-dfs.sh, I get the following error: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable HELP! I need help understanding this Error.
asked Mar 19 Shovo210 13.3k points
0 votes
1 answer 97 views
97 views
Failed to locate the winutils binary in the hadoop binary path.
Problem: I am beginner to python and pyspark. I am trying to start the very simple app with the help of spark. I have already downloaded the spark with the help of following command: pip install spark. But now if I try to run the code below error occurs: Failed to ... ']= "C:\\winutils" lines = sc.textFile("ob.txt") pythonLines = lines .filter(lambda line: "python" in line) print(pythonLines)
asked Jul 28, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 14 views
14 views
org.apache.poi.emptyfileexception: the supplied file was empty (zero bytes long)
Problem: I'm having difficulties, as I described in my previous question. I tried looking it up but couldn't come up with something useful. Is it possible for you to help me?
asked Apr 3 salim1 34.8k points
0 votes
1 answer 4 views
4 views
Org/apache/commons/collections4/listvaluedmap
Problem: I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my requirements. I'm attempting to move to XSSF, but I keep getting errors when trying to use it: Apache POI error loading XSSFWorkbook class
asked Apr 2 ummesalma 24.5k points
0 votes
1 answer 2 views
2 views
The inter process communication between different nodes in hadoop uses
Problem: When I setup the hadoop cluster, I read the namenode runs on 50070 and I set up accordingly and it's running fine. But in some books I have come across name node address : hdfs://localhost:9000/
asked 1 day ago ummesalma 24.5k points
0 votes
1 answer 2 views
2 views
What is edge node in hadoop
Problem Actually, I want to know more about What is edge node in Hadoop? If someone could clarify what this means that'd be great!
asked Mar 8 neeraj 9.5k points
0 votes
1 answer 2 views
2 views
unable to find driver for this platform acpi
Problem: I have an issue that i am unable to find driver for this platform acpi can anybody solve this issue.
asked Mar 22 waseem memon 2.4k points
0 votes
1 answer 2 views
2 views
git://git.apache.org/hadoop-common.git.
Problem Can someone help me with this problem, "git://git.apache.org/hadoop-common.git?"
asked 6 days ago salim1 34.8k points
Dark theme