Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Not able to start the hive metastore

Copy link to this message
Re: Not able to start the hive metastore
Nitin Pawar 2013-12-09, 06:53
Try changing the permissions of the new directory to the user as whom you
are going to start metastore service.

On Mon, Dec 9, 2013 at 12:17 PM, Biswajit Nayak

> Hi All,
> I had setup the hive in my home directory, but today i moved it to /opt.
> After that starting it throws error:-
> *Exception in thread "main" javax.jdo.JDOFatalDataStoreException: Unable
> to open a test connection to the given database. JDBC url > jdbc:derby:;databaseName=metastore_db;create=true, username = APP.
> Terminating connection pool. Original Exception: ------*
> *java.sql.SQLException: Failed to start database 'metastore_db', see the
> next exception for details.*
> * at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)*
> * at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)*
> * at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)*
> * at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)*
> * at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)*
> *Thanks*
> *Biswajit*
> _____________________________________________________________
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.
Nitin Pawar