Hive failed to metastore database

Question

After running hive command it failed to create database

Following the official "Getting Started" guide on Apache website

NestedThrowables:
java.sql.SQLException: Unable to open a test connection to the given 
database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true,  
username = APP. Terminating connection pool (set lazyInit to true if you   
expect to start your database after your app). Original Exception: ------
java.sql.SQLException: Failed to create database 'metastore_db', see the  next exception for details.

Caused by: java.sql.SQLException: Directory /opt/hive/bin/metastore_db cannot be created.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
... 80 more
Caused by: ERROR XBM0H: Directory /opt/hive/bin/metastore_db cannot be created.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
... 80 more

score 1 · Answer 1 · answered Jul 10 '18 at 07:01

I just realized in hive: hive-site.xml and in the installation steps to create /user/hive/warehouse:

"user" can be so easily confused with "usr" without any alert at all. so remember:

under hadoop fs, this is /user/hive/warehouse, which points to metadata_db folder, to create (NOT /usr/hive/warehouse)

score 0 · Answer 2 · answered Nov 11 '16 at 12:27

0

check the particular user have permission to create /opt/hive/bin/metastore_db

if not then add permission

sudo chmod -R 777 /opt/hive/bin/metastore_db

hope this helps

answered Nov 11 '16 at 12:27

Nirmal Ram

1,180
2
9
18

I'm getting this error - chmod: cannot access `/opt/hive/bin/metastore_db': No such file or directory – Sushil Nov 14 '16 at 07:18
first give "sudo mkdir -p /opt/hive/bin/metastore_db" – Nirmal Ram Nov 14 '16 at 07:20
Caused by: java.sql.SQLException: Failed to create database 'metastore_db', see the next exception for details. - I'm getting the same error which i have posted above. I'm trying to start the hive – Sushil Nov 14 '16 at 07:33
what you get when you type "touch /opt/hive/bin/metastore_db/a" – Nirmal Ram Nov 14 '16 at 07:40
This command running successfully when i'm running hive then i get - Caused by: java.sql.SQLException: Failed to create database 'metastore_db' – Sushil Nov 14 '16 at 08:07
Paste your hive-site.xml – Nirmal Ram Nov 14 '16 at 08:18
Where can i find hive-site.xml? I'm beginner to hadoop – Sushil Nov 14 '16 at 08:37
in hive conf path – Nirmal Ram Nov 14 '16 at 08:50
there is no file hive-site.xml in path - opt/hive/conf – Sushil Nov 14 '16 at 08:56
what do you have in conf path – Nirmal Ram Nov 14 '16 at 09:10
hive-default.xml.template this file in conf folder – Sushil Nov 14 '16 at 09:13
do as per steps given in http://stackoverflow.com/questions/27239568/hive-site-xml-path-in-hive0-13-1 – Nirmal Ram Nov 14 '16 at 09:41

score 0 · Answer 3 · answered Jul 09 '18 at 15:34

use: chown -R hduser:hduser * xxxxxxxxx/hive/ (*or whatever username /usergroup you are using) to grant owner (hence full permission.....incl write/create)

(I dont know whether there is a default hive user/group named hive:hive, i created this but granting the ownership right to this hive user created wont work..)

basically the installation instruction assumes you (the hadoop and hence hive who inherit your right) have sufficient permissions.

(note: this is kind of equivalent to run command prompt in Admin Mode in windows, even though you are already admin). Linux tends to be flexible in many things so cause some chaos.

Hive failed to metastore database

3 Answers3