• Register
1 vote

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

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
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
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
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
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
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
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
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
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
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
Problem Can someone help me with this problem, "git://git.apache.org/hadoop-common.git?"
asked 6 days ago salim1 34.8k points