java.sql.SQLException: Failed to start database '/var/lib/hive/metastore/metastore_db' in hive

Question

I am a starter to hive. When I try to execute any hive commands:

hive>SHOW TABLES;

it's showing the below error:

FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to start database '/var/lib/hive/metastore/metastore_db', see the next exception for details.
NestedThrowables:
java.sql.SQLException: Failed to start database '/var/lib/hive/metastore/metastore_db', see the next exception for details.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

The question is answered by me [here][1] [1]: stackoverflow.com/questions/15761139/… — Dexter
– Dexter, Commented Aug 30, 2014 at 23:16

SachinJose · Accepted Answer · 2014-03-26 04:39:00Z

5

It looks like derby locking issue. you can temporarily fix this issue by deleting the lock file inside the directory /var/lib/hive/metastore/metastore_db. But this issue will also occur in future also

sudo rm -rf /var/lib/hive/metastore/metastore_db/*.lck

With default hive metastore embedded derby, it is not possible to start multiple instance of hive at the same time. By changing hive metastore to mysql or postgres server this issue can be solved.

See the following cloudera documentation for changing hive metastore

http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html

answered Mar 26, 2014 at 4:39

SachinJose

8,5224 gold badges45 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

matemaciek · Accepted Answer · 2017-11-14 10:35:25Z

2

I've encountered similar error when I forgot about another instance of spark-shell running on same node.

answered Nov 14, 2017 at 10:35

matemaciek

6317 silver badges11 bronze badges

Comments

Samer · Accepted Answer · 2015-12-08 18:49:08Z

1

update hive-site.xml under ~/hive/conf folder as below name/value and try this:

 <name>javax.jdo.option.ConnectionURL</name>
 <value>jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true</value>

edited Dec 8, 2015 at 18:49

Samer

2,0003 gold badges34 silver badges61 bronze badges

answered Dec 8, 2015 at 18:23

Azam Khan

5395 silver badges13 bronze badges

Comments

Janusz · Accepted Answer · 2018-05-08 13:04:04Z

0

In my case I needed to create a directory and grant proper permissions:

$ sudo mkdir /var/lib/hive/metastore/
$ sudo chown hdfs:hdfs /var/lib/hive/metastore/

answered May 8, 2018 at 13:04

Janusz

1,51113 silver badges17 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: Failed to start database '/var/lib/hive/metastore/metastore_db' in hive

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related