title: Hive keep using derby instead of mysql
body: <p>I'm new on using Hive, I got problem because at first I use derby and now I want to use mysql, but when I check the error log it still hitting the derby how to change from derby to mysql? thank you</p>
  <p>I run this
  <code>schematool -dbType mysql -initSchema --verbose</code></p>
  <p>but ends to have this</p>
  <pre><code>SLF4J: Class path contains multiple SLF4J bindings.
  SLF4J: Found binding in [jar:file:/usr/local/Cellar/hive/3.1.2_3/libexec/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: Found binding in [jar:file:/usr/local/Cellar/hadoop/3.3.1/libexec/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
  Metastore connection URL:    jdbc:derby:;databaseName=metastore_db;create=true
  Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver
  Metastore connection User:   APP
  Starting metastore schema initialization to 3.1.0
  Initialization script hive-schema-3.1.0.mysql.sql
  Connecting to jdbc:derby:;databaseName=metastore_db;create=true
  Connected to: Apache Derby (version 10.14.1.0 - (1808820))
  Driver: Apache Derby Embedded JDBC Driver (version 10.14.1.0 - (1808820))
  Transaction isolation: TRANSACTION_READ_COMMITTED
  0: jdbc:derby:&gt; !autocommit on
  Autocommit status: true
  0: jdbc:derby:&gt; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
  Error: Syntax error: Encountered &quot;&lt;EOF&gt;&quot; at line 1, column 64. (state=42X01,code=30000)
  Closing: 0: jdbc:derby:;databaseName=metastore_db;create=true
  org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent
  </code></pre>
  <p>I already change the hive-site.xml but it still the same</p>
  <pre><code>   &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
        &lt;value&gt;jdbc:mysql://127.0.0.01:3306/metastore?createDatabaseIfNotExist=true&amp;useSSL=false&lt;/value&gt;
        &lt;description&gt;metadata is stored in a MySQL server&lt;/description&gt;
     &lt;/property&gt;
  </code></pre>
  <p>Thank you very much for your help</p>