Writing data to the table - 7.0

Hive

EnrichVersion
7.0
EnrichProdName
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 Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
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

Configuring tHiveLoad

Procedure

  1. Double-click tHiveLoad to open its Component view.
  2. Select the Use an existing connection check box and from Component list, select the connection configured in the tHiveConnection component you are using for this Job.
  3. From the Load action field, select LOAD to write data from the file holding the sample data that is presented at the beginning of this scenario.
  4. In the File path field, enter the directory where the sample data is stored. In this example, the data is stored in the HDFS system to be used.

    In the real-world practice, you can use tHDFSOutput to write data into the HDFS system and you need to ensure that the Hive application has the appropriate rights and permissions to read or even move the data.

    For further information about tHDFSOutput, see tHDFSOutput.

    for further information about the related rights and permissions, see the documentation or contact the administrator of the Hadoop cluster to be used.

    Note if you need to read data from a local file system other than the HDFS system, ensure that the data to be read is stored in the local file system of the machine in which the Job is run and then select the Local check box in this Basic settings view. For example, when the connection mode to Hive is Standalone, the Job is run in the machine where the Hive application is installed and thus the data should be stored in that machine.
  5. In the Table name field, enter the name of the target table you need to load data in. In this scenario, it is employees.
  6. From the Action on file list, select APPEND.
  7. Select the Set partitions check box and in the field that appears, enter the partition you need to add data to. In this scenario, this partition is country='US'.