Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.



D s platform

Configure Hive Locations

If you are enabling an integration with Hive on the Hadoop cluster, there are some distribution-specific parameters that must be set. For more information, see Configure for Hive.

Configure SSL for Hive

CDH supports two methods of enabling SSL communications with Hive:

  1. SASL-QOP method: Enable encryption between Hive JDBC and HiveServer 2 using SASL-QOP. This method is available by default with the
    D s platform
  2. TLS/SSL method: Use TLS/SSL encryption for JDBC connections to HiveServer 2.

To determine the method in use:

  1. In Cloudera Manager configuration, search for: tls.
  2. If the options for TLS/SSL are enabled, please complete the following configuration steps.
  3. If these options are not enabled, the cluster can still use the SASL-QOP method. For more information on this method, see Configure for Hive .

Enable TLS/SSL Method


  1. The default Hive JDBC driver provided with your

    D s item
    must be replaced with the drive provided by Cloudera. Please complete the following commands, noting the wildcards (*) in the JAR path:


    NOTE: The current driver must be removed or replaced in the working directory. Do not leave it in the directory.

    Code Block
    cd /opt/trifacta/services/data-service/build/dependencies
    rm *hive*jdbc*
    cp /opt/cloudera/parcels/CDH-5.8*/jars/hive-jdbc-1.1.0-cdh5.8.0*jar .



  2. Enable the Hive connection. For the Hive connection string options, you must specify something like the following:

    Code Block
        "connectStrOpts": ";ssl=true;sslTrustStore=</path/to/truststore>;trustStorePassword=<storePassword>"

    NOTE: The truststore specified above must exist on the

    D s item
    and be accessible to the
    D s item
    through the listed password. This truststore must contain the certificate for the Hive server.

  3. Save the parameters file. For more information on creating the connection, see Configure for Hive.

  4. Restart the platform. See Start and Stop the Platform.
  5. Verify that you can read from a Hive source through the application. See Hive Browser.