Configuring a DSN-less Connection

Some client applications provide support for connecting to a data source using a connector without a Data Source Name (DSN). To configure a DSN-less connection, you can use a connection string or the Simba Hive ODBC Driver Configuration tool that is installed with the Simba Apache Hive ODBC Connector. Settings in a connection string apply only when you connect to Hive using that particular string, while settings in the connector configuration tool apply to every connection that uses the Simba Apache Hive ODBC Connector.

The following section explains how to use the connector configuration tool. For information about using connection strings, see Using a Connection String.

Note:

  • Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.
  • The drop-down lists in the connector configuration tool only display one option at a time. Use the scroll arrows on the right side of the drop-down list to view and select other options.

To configure a DSN-less connection using the connector configuration tool:

  1. Choose one:
    • If you are using Windows 7 or earlier, click Start Windows Start button > All Programs > Simba Apache Hive ODBC Connector 2.6 > Driver Configuration.
    • Or, if you are using Windows 8 or later, click the arrow button at the bottom of the Start screen, and then click Simba Apache Hive ODBC Connector 2.6 > Driver Configuration.

    Note:

    Make sure to select the Driver Configuration Tool that has the same bitness as the client application that you are using to connect to Hive.

  2. If you are prompted for administrator permission to make modifications to the machine, click OK.

    3. Note:

    You must have administrator access to the machine to run this application because it makes changes to the registry.

  3. In the Hive Server Type drop-down list, select Hive Server 1 or Hive Server 2.

    4. Note:

    If you are connecting through Apache ZooKeeper, then Hive Server 1 is not supported.

  4. Specify whether the connector uses the ZooKeeper service when connecting to Hive:
    • To connect to Hive without using the Apache ZooKeeper service, from the Service Discovery Mode drop-down list, select No Service Discovery.
    • Or, to discover Hive Server 2 services via the ZooKeeper service, do the following:
      1. From the Service Discovery Mode drop-down list, select ZooKeeper.
      2. In the Host(s) field, type a comma-separated list of ZooKeeper servers. Use the following format, where [ZK_Host] is the IP address or host name of the ZooKeeper server and [ZK_Port] is the number of the TCP port that the ZooKeeper server uses to listen for client connections:

        [ZK_Host1]:[ZK_Port1],[ZK_Host2]:[ZK_Port2]

      3. In the ZooKeeper Namespace field, type the namespace on ZooKeeper under which Hive Server 2 znodes are added.
  5. In the Authentication area, configure authentication as needed. For more information, see Configuring Authentication.

    6. Note:

    Hive Server 1 does not support authentication. Most default configurations of Hive Server 2 require User Name authentication. To verify the authentication mechanism that you need to use for your connection, check the configuration of your Hadoop / Hive distribution. For more information, see Authentication Mechanisms.

  6. Optionally, if the operations against Hive are to be done on behalf of a user that is different than the authenticated user for the connection, then in the Delegation UID field, type the name of the user to be delegated. For more information, see Delegating Authentication to a Specific User.

    7. Note:

    This option is applicable only when connecting to a Hive Server 2 instance that supports this feature.

  7. In the Thrift Transport drop-down list, select the transport protocol to use in the Thrift layer.

    8. Note:

    For information about how to determine which Thrift transport protocols your Hive server supports, see Authentication Mechanisms.

  8. If the Thrift Transport option is set to HTTP, then to configure HTTP options such as custom headers, click HTTP Options. For more information, see Configuring HTTP Options.
  9. To configure the connector to connect to Hive through a proxy server, click Proxy Options. For more information, see Configuring a Proxy Connection.
  10. To configure client-server verification over SSL, click SSL Options. For more information, see Configuring SSL Verification.

    11. Note:

    If you selected User Name as the authentication mechanism, SSL is not available.

  11. To configure advanced options, click Advanced Options. For more information, see Configuring Advanced Options.
  12. To configure server-side properties, click Advanced Options and then click Server Side Properties. For more information, see Configuring Server-Side Properties.
  13. To save your settings and close the Simba Hive ODBC Driver Configuration tool, click OK.

Related topics