How to Load data from Hive table to mysql DB tables

[Anonymous]

Hi,
Could some one please help here on how to extract data from 'Hive' tables and load them into 'mysql' db tables?
Point me if any of the old posts/use case discusses and resolved already in this forum.
Thanks in advance.
Cheers.

[Anonymous]

Hi,

Please take a look at a related forum:https://community.talend.com/t5/Design-and-Development/How-to-integrate-MSSQL-with-Hive/td-p/86037

Usually, we use TalendHelpCenter:tSqoopExport to call sqoop to transfer data from the Hadoop Distributed File System (HDFS) to a relational database management system (RDBMS), such as, MySQL, MSSQL.

Best regards

Sabrina

 

[Anonymous]

Assuming you are using Talend Bigdata, if you are using bigdata batch job
For spark , we have tHiveinput and tmysqlloutput components.
For mapreduce, Hive uses HDFS as the underlying file system,you can use tHDFSInput and tmysqloutput components.