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
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