Reply
Highlighted
Explorer
Posts: 9
Registered: ‎08-29-2017

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: 146
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
Announcements