Configuring the connection to Hive

About this task

Configuring tHiveConnection

Double-click tHiveConnection to open its Component view.
From the Property type list, select Built-in. If you have created the connection to be used in Repository, then select Repository, click the button to open the Repository content dialog box and select that connection. This way, Talend Studio will reuse that set of connection information for this Job.
For further information about how to create a Hadoop connection in Repository, see Centralizing Hadoop connections.
In the Version area, select the Hadoop distribution to be used and its version. If you cannot find from the list the distribution corresponding to yours, select Custom so as to connect to a Hadoop distribution not officially supported in Talend Studio.
For a step-by-step example about how to use this Custom option, see Connecting to a custom Hadoop distribution.
In the Connection area, enter the connection parameters to the Hive database to be used.
In the Name node field, enter the location of the master node, the NameNode, of the distribution to be used. For example, talend-hdp-all:50300. If you are using WebHDFS, the location should be webhdfs://masternode:portnumber; WebHDFS with SSL is not supported yet.
In the Job tracker field, enter the location of the JobTracker of your distribution. For example, hdfs://talend-hdp-all:8020.
Note that the notion Job in this term JobTracker designates the MR or the MapReduce jobs described in Apache's documentation on http://hadoop.apache.org/.

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