Skip to main content Skip to complementary content

Configuring a DataBase Connection to Hive

About this task

This example uses version 3.6 of Azure HDInsight.

Procedure

  1. In the Repository view, extend the Metadata drop-down menu.
  2. Click Db Connections, and then right-click Create Connection .
  3. Give a name to your connection.
  4. Click Next.
  5. Set up the connection configuration similarly to the following table:

    DB Type

    Select Hive.

    Hadoop Cluster

    Select None.

    Distribution

    Select Horton Works.

    HDInsight is leveraging Horton Works distribution on the backend. This will allow you to use Horton Works libraries to connect to HDInsighs.

    DB Type

    Select Hive.

    Version

    Select Hortonworks Data Platform V2.6.0.3-8 [Built in].

    Hive Model

    Select Standalone.

    Login

    Password

    Server

    Fill in the fields as required.

    Port

    Input 443.

    You will be able to communicate through the proxy port since the HDInsight cluster sits behind a proxy by default.

    DataBase

    Leave default.

    Additional JDBC Setting

    Input transportMode=http;ssl=true;httpPath=/hive2, where:
    • transportMode=http sets the transport mode to HTTP instead of the default Hive JDBC transport mode.
    • SSL=true enables SSL.
    • httpPath=/hive2 sets the HTTP endpoint.
  6. Click Test Connection to ensure the Talend Studio connects successfully to the cluster.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!