HIVE not working, No suitable driver found for jdbc:derby://localhost:1527

I switched to mysql as a metastore DB, setting up derby had already wasted a lot of my time. Here's the tutorial I followed saurzcode.in/2015/01/configure-mysql-metastore-hive/ .

I followed the same tutorial and faced the same issue. Try to simply copy jar files:

`cp /usr/local/derby/lib/derbyclient.jar /usr/local/hive/lib/``cp /usr/local/derby/lib/derbytools.jar /usr/local/hive/lib`

Note that:

• I have installed hive-2.1.1.
• I don't use the same ConnectionURL, I use jdbc:derby://localhost:1527//usr/local/derby/data/metastore_db;create=true
• You need to start derby derby/bin/startNetworkServer
• I tried to manually initialize the schema (I don't if it's needed, or automatically performed by Hive): schematool -dbType derby -initSchema

The suitable driver for a JDBC Connection URL of the form jdbc:derby://host:port/... is the Derby Client driver located in derbyclient.jar.

From the output you included, it doesn't look like you have derbyclient.jar in your CLASSPATH.

Try putting derbyclient.jar into your CLASSPATH and see if that fixes the problem, or at least allows you to make further progress.