topic Re: How to Load data from Hive table to mysql DB tables in Talend Studio

How to Load data from Hive table to mysql DB tables

Anonymous — Sat, 16 Nov 2024 10:36:01 GMT

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.

Re: How to Load data from Hive table to mysql DB tables

Anonymous — Wed, 15 Jun 2016 10:28:03 GMT

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

Re: How to Load data from Hive table to mysql DB tables

Anonymous — Fri, 17 Jun 2016 01:58:57 GMT

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.