How to Load data from Hive table to mysql DB tables

One Star

How to Load data from Hive table to mysql DB tables

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.
Moderator

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

Hi,


Please take a look at a related forum:https://www.talendforge.org/forum/viewtopic.php?id=47786


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


 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

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

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. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now