Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop from Impala and Hive to MYSQL

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

1 REPLY 1

Re: Sqoop from Impala and Hive to MYSQL

Guru
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