Reply
Highlighted
Former Member
Posts: 0

Sqoop from Impala and Hive to MYSQL

I have a table in Hive i want to sqoop to mysql it it possible?


similarly I have a table in Impala Can i sqoop it to MYSQL.

 


Is it possible. whats the syntax if so. Thanks

Cloudera Employee
Posts: 724
Registered: ‎03-23-2015

Re: Sqoop from Impala and Hive to MYSQL

Hi,

Sqoop supports imports and exports. The name is relative to HDFS.

Import means copy data from relational database into HDFS

Export means copy data from within HDFS into relational database.

In your case you are referring to the export feature that sqoop provides, please go through the documentation for details:

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_literal_sqoop_export_literal