Setting up a JDBC URL connection override

You can configure fine-grained tuning of the HMS database connection. You specify a JDBC URL override, which depends on your database, for establishing a connection to the Hive metastore database.

This task is intended for advanced database users only. When using this override, the following properties are overwritten
  • Hive Metastore Database Name
  • Hive Metastore Database Host
  • Hive Metastore Database Port
  • Enable TLS/SSL to the Hive Metastore Database
  • The required default user role is Configurator.
  • You know the values for setting the following properties:
    • Hive Metastore Database Type
    • Hive Metastore Database User
    • Hive Metastore Database Password
  1. Set the value of the Hive Metastore Database JDBC URL Override property according to your cluster configuration.
    • MySQL
      jdbc:mysql://<host>:<port>/<metastore_db>?key=value
    • PostgreSQL
      jdbc:postgresql://<host>:<port>/<metastore_db>?key=value
    • Oracle JDBC Thin using a Service Name
      jdbc:oracle:thin:@//<host>:<port>/<service_name>
    • Oracle JDBC Thin using SID
      jdbc:oracle:thin:@<host>:<port>:<SID>
    • Oracle JDBC Thin using TNSName
      jdbc:oracle:thin:@<TNSName>
  2. Click Save.
  3. Click Actions > Deploy Client Configuration.
  4. Restart Hive Metastore.