Configuring a DataBase Connection to Hive - Cloud - 8.0

Hive

Version
Cloud
8.0
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components > Hive components
Data Quality and Preparation > Third-party systems > Database components > Hive components
Design and Development > Third-party systems > Database components > Hive components

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.