Support Questions
Find answers, ask questions, and share your expertise

Sqoop to MYSQL from Impala and Hive

 
1 REPLY 1

Re: Sqoop to MYSQL from Impala and Hive

Contributor

@Gayathri Devi You can export hive table to mysql using sqoop. You can refer to the syntax below -

sqoop export --connect jdbc:mysql://127.0.0.1/export --username hive --password hive --table exported --direct --export-dir /apps/hive/warehouse/export_table --driver com.mysql.jdbc.Driver

Please make sure the table is created in mysql before exporting the data. Please give it a try and let me know if you face any issue.