Try changing the permissions of the new directory to the user as whom you are going to start metastore service.
Thanks, Nitin On Mon, Dec 9, 2013 at 12:17 PM, Biswajit Nayak <biswajit.na...@inmobi.com>wrote: > 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