Hi, Looks like you are passing the 'dbType' as derby however the Metastore connection URL is configured (hive-site.xml) for mysql. Both Hive and schemaTool will use the metastore URL and driver configured in the hive-site to connect to the database. If you intend to use derby as backend, please set the javax.jdo.option.ConnectionURL and javax.jdo.option.ConnectionDriverName parameters accordingly.
thanks Prasad On Thu, Jan 30, 2014 at 12:58 AM, unmesha sreeveni <[email protected]>wrote: > > Hive metastore is creating mysql instead of Derby. > > schematool -dbType derby -initSchema > Metastore connection URL: jdbc:mysql://localhost/metastore > Metastore Connection Driver : com.mysql.jdbc.Driver > Metastore connection User: hive > > schematool -dbType derby -info > Metastore connection URL: jdbc:mysql://localhost/metastore > Metastore Connection Driver : com.mysql.jdbc.Driver > Metastore connection User: hive > org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver > *** schemaTool failed *** > What is the issue . > > I am running Hive 0.12 > > -- > *Thanks & Regards* > > Unmesha Sreeveni U.B > > > >
