Skip to main content Skip to complementary content

Step 1: Loading the database table data into the Hive internal table

Procedure

  1. Create a standard Job to load the database table data into the Hive internal table employee.
  2. Use the tHiveCreateTable and tHiveLoad components to load the data into the Hive table.
  3. The Talend Big Data Batch Job is as follow:
    • The data are moved from the MySQL source table employee_table to the employee table in Hive.
    • The tHiveConfiguration_1 and tHDFSConfiguration_1 components set the Hive and HDFS configuration.
    • The tMysqlInput component reads the data from the MySQL database.
    • The tHiveOutput component loads the data into the Hive table.
  4. Run the Job.
    The following shows the data in the employee Hive table after this Job is run:

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!

Leave your feedback here