- Create a standard Job to load the database table data into the Hive internal table employee.
- Use the tHiveCreateTable and tHiveLoad components to load the data into the Hive table.
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.
Run the Job.
The following shows the data in the employee Hive table after this Job is run: