Cloudera Docs

Configuring global Hive JDBC URL for Oozie

Learn how to configure a global Hive JDBC URL for Oozie workflows built using Data Explorer. This allows you to set a default connection string across the cluster while retaining the flexibility to override it for individual workflows.

Data Explorer automatically generates the Hive JDBC URL for Oozie workflows based on the default Hive service configuration. If you require a different connection string, such as a ZooKeeper quorum for High Availability (HA), you previously had to manually specify the URL for every individual Oozie workflow.

You can now define a global oozie_hs2_jdbc_url that applies to all Oozie workflows built using Data Explorer across the cluster. While this setting provides a global default, you can still override it at the individual workflow level if a specific project requires a different connection.

  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue > Configuration.
  3. Search for the Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini.
  4. Add the oozie_hs2_jdbc_url property under the [oozie] section as follows: 
    [oozie]
# Example: Global ZooKeeper quorum-based URL
oozie_hs2_jdbc_url=jdbc:hive2://<zk_host1>:2181,<zk_host2>:2181/default;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

    Replace the placeholders with your actual ZooKeeper hosts and namespace or the Hive JDBC URL intended to be used by the Oozie workflows.

  5. Click Save Changes.
  6. Restart the Data Explorer service.