how to find hive metastore is using derby or MYSQL as database?

I am trying to find the hive remote meta-store is using Derby or MYSQL as database?

Is there a way to find this?

Check your hive-site.xml.

If there are following lines:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://<host name>/<database name>..</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>

Your meta-store in mysql.

<property>
  <name>javax.jdo.option.ConnectionURL</name> 
  <value>jdbc:derby:;databaseName=../build/test/junit_metastore_db;create=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>

Your meta-store in derby.

More about configure meta-store

---

EDIT

If the above line not in hive-site.xml, try searching in hive-default.xml.template and hivemetastore-site.xml.

More about the conf files:

1. hive-default.xml.template contains the default values for various configuration variables that come prepackaged in a Hive distribution.

2. In order to override any of the values, create hive-site.xml instead and set the value in that file as shown above.

3. You can set metastore-specific configuration values in hivemetastore-site.xml.

BTW: Derby is the default database for the Hive metastore (Metadata Store).

If you want to read more, the official docs