Hive Metastore is not creating MYSQL or Derby Connection

I think the problem is with your URL. Modify the URL as follows. Put the mysql port no.

Metastore connection URL: jdbc:mysql://localhost:3306/metastore

If you want to access Derby, I suspect these should be something like:

Metastore connection URL:    jdbc:derby://localhost:1527/metastoreMetastore Connection Driver :    org.apache.derby.jdbc.ClientDriver

instead of

Metastore connection URL:    jdbc:mysql://localhost/metastoreMetastore Connection Driver :    com.mysql.jdbc.Driver

mysql hadoop hive derby

For this specific error "Failed to load driver", you should check if you have the mysql connector copied or has a link in Hive lib folder.

ln -s /usr/share/java/mysql-connector-java.jar $HIVE_HOME/lib/mysql-connector-java.jar

(Download it if you don't have it within the Java libs)

Similarly get the lib for Derby too.

CodeHunter