Using Windows Azure HDInsight Service

This authentication mechanism is available only for Hive Server 2 on HDInsight distributions. When you use this authentication mechanism, you must enable SSL and HTTP is the only Thrift transport protocol available.

To configure a connection to a Hive server on Windows Azure HDInsight Service:

  1. Choose one:
    • To access authentication options for a DSN, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
    • Or, to access authentication options for a DSN-less connection, open the Simba Hive ODBC Driver Configuration tool.
  2. From the Mechanism drop-down list, select Windows Azure HDInsight Service.
  3. In the User Name field, type an appropriate user name for accessing the Hive server.
  4. In the Password field, type the password corresponding to the user name you typed abpve.
  5. To save the password, select the Save Password (Encrypted) check box.
    6. Important:

    Important:

    The password is obscured, that is, not saved in plain text. However, it is still possible for the encrypted password to be copied and used.

  6. Click HTTP Options, and in the HTTP Path field, type the partial URL corresponding to the Hive server. Click OK to save your HTTP settings and close the dialog box.

    7. Note:

    If necessary, you can create custom HTTP headers. For more information, see Configuring HTTP Options.

  7. Click SSL Options and configure SSL settings as needed. For more information, see Configuring SSL Verification.
  8. Click OK to save your SSL configuration and close the dialog box, and then click OK to save your authentication settings and close the dialog box.

Related topics