menu
  • Register

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

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

1 vote
163 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 28 views
28 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
0 votes
1 answer 53 views
53 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 2.3K views
2.3K views
Org.apache.kafka.common.errors.timeoutexception: failed to update metadata after 60000 ms
Problem : I am trying to produce the message in kafka, but i am getting the following error : Error when sending message to topic nil_PF1_P1 with key: null, value: 2 bytes with error: (org.apache.kafka.clients.producer.internals.ErrorLoggingCallback ... .ErrorLoggingCallback) org.apache.kafka.common.errors.TimeoutException: Failed to update metadata after 60000 ms. Any suggestions on this issue??
asked Nov 28, 2019 alecxe 7.5k points
0 votes
1 answer 1.2K views
1.2K views
Apache couldn't be started because port 8888 is in use by some other software.
Problem : When attempting to start the servers, Apache fails to start, and MAMP claims that my port ([::]:8888) is already in the use. I have tried virtually every way I know of determining what the process is using that port (as well as many of other solutions ... what(if anything) is really using my port, or somehow convince the MAMP that my port is not actually in use. Any suggestions on this?
asked Jan 17, 2020 jwilliam 3.9k points
0 votes
1 answer 1.7K views
1.7K views
Apache couldn't be started. please check your mamp installation and configuration.
Problem : I want to view my php files locally on my mac. I am trying to run Yosemite on my mac. I have the MAMP installed on my mac. When I press start my MySQL server starts as usual but my Apache doesn't start at all. An error message is shown ... also tried reinstalling the OSX and that worked but until I shut down my mac the problem reoccurs. Can anyone help with the solution on above error?
asked Dec 19, 2019 alecxe 7.5k points
1 vote
1 answer 870 views
870 views
Kinit: preauthentication failed while getting initial credentials.
Problem: I am very new to Kerberos and Hadoop. I tried to create the "user.keytab" file by "ktutil" to try to renew a krb ticket without the use of the password as it was recommended in some online tutorial. Please find below the procedure I ... credentials Please find below my environment details for your reference: My OS: Centos Linux, My Cluster: Cloudera Hadoop Distribution, My Tool: Kerberos
asked May 27, 2020 Martin K 6.6k points
1 vote
1 answer 109 views
109 views
Error: can't get master address from zookeeper; znode data == null.
Problem : I am very new to Hadoop and Hbase. I have very recently installed Hadoop2.2.0 and Hbase0.98.0 and after that I followed below procedure : $ ./bin/start-hbase.sh $ ./bin/hbase shell 2.0.0-p353 :001 > list But after following above procedure I am facing ... four days on it but unable to fix it. So now I am looking for Hadoop and Hbase experts help who can help me in fixing above error.
asked May 5, 2020 stewart 4k points
0 votes
1 answer 15 views
15 views
Forbidden you don't have permission to access / on this server.
Problem: I have searched online for the solution on my problem related to permission issues but I am unable to find any suitable answer which can fix my problem. My problem is that I am unable to access my app folders in the var/www/ folder. If I try to go to ... folder-name/ on this server. Apache/2.2.22 (Ubuntu) Server at localhost Port 80 Does anybody ever faced above 403 error and fixed it?
asked Jul 13, 2020 Raphael Pacheco 4.9k points
1 vote
1 answer 84 views
84 views
Server tomcat v8.0 server at localhost failed to start. in eclipse.
Problem: I am very new to Web.xml coding. Currently I am facing serious problem because of my web.xml file. If I try to run my Apache tomcat 8 server then every time it shows me below error: Server tomcat v8.0 server at localhost failed to start. in eclipse. If I ... . This error made my life like the hell. So I am looking for the help from web.xml expert who can help me in fixing my problem.
asked May 18, 2020 Martin K 6.6k points
Dark theme