java.sql.SQLException: Failed to start database 'metastore_db' ERROR, while initializing database using hive

Question

I installed Hadoop and Hive on 3 cluster. I have able to login to hive from my cluster node where HIVE is running.

root@NODE_3 hive]# hive Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-0.10.0-cdh4.2.0.jar!/hive-log4j.properties Hive history file=/tmp/root/hive_job_log_root_201304020248_306369127.txt hive> show tables ; OK Time taken: 1.459 seconds hive>

But when i try to run some hive test on my cluster nodes , I am getting following given below error.

Here it is trying to initilize data base as user =ashsshar{my username}

3/04/02 02:32:44 INFO mapred.JobClient: Cleaning up the staging area hdfs://scaj-ns/user/ashsshar/.staging/job_201304020010_0080 13/04/02 02:32:44 ERROR security.UserGroupInformation: PriviledgedActionException as:ashsshar (auth:SIMPLE) cause:java.io.IOException: javax.jdo.JDOFatalDataStoreException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details. NestedThrowables: java.sql.SQLException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details. java.io.IOException: javax.jdo.JDOFatalDataStoreException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details. NestedThrowables: java.sql.SQLException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details.

I have tried two things .

1 . Giving permission to cd /var/lib/hive/metastore/metastore_db

Removing rm /var/lib/hive/metastore/metastore_db/*lck

But still i am getting the same error

ARe u using a separate metestore or the embedded DB (Derby DB?) Please explain your setup little bit in more detail — Rags
– Rags, Commented Apr 2, 2013 at 19:55
Yes i am using Derby Db .| The following property is defined in my hive-site.xml file. <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true</value> — Ashish Sharma
– Ashish Sharma, Commented Apr 4, 2013 at 8:14

Dexter · Accepted Answer · 2014-08-30 23:13:43Z

2

It seems to be an issue with creating the metastore. I solved this by creating a directory and setting the value to that directory as follows:

step-1: create a directory on home say its: hive-metastore-dir

step-2: being super user edit the hive-site.xml (its in: /usr/lib/hive/conf) as follows:

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

to

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

step-3: start the CLI as sudo hive and perform your queries.

answered Aug 30, 2014 at 23:13

Dexter

4,3433 gold badges52 silver badges56 bronze badges

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

1 Comment

Metadata Over a year ago

Is this an empty directory ? '/home/hive-metastore-dir/metastore/metastore_db' or do we need additional files in it ?

Harikrishnan Ck · Accepted Answer · 2017-03-07 22:21:21Z

0

You may login to hive client from a directory where the user has write access. By default, hive will try to create temporary directory in local and HDFS when a shell is opened up.

answered Mar 7, 2017 at 22:21

Harikrishnan Ck

9301 gold badge11 silver badges12 bronze badges

Comments

Chandan Kumar Behera · Accepted Answer · 2018-01-10 17:04:12Z

0

follow this steps if you are using CDH 1. copy /usr/lib/hive/conf/hive-site.xml and paste into /usr/lib/spark/conf/

This will solve the problem of "metastore_db" error

Thanks

answered Jan 10, 2018 at 17:04

Chandan Kumar Behera

12 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: Failed to start database 'metastore_db' ERROR, while initializing database using hive

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related