Question: how to export data from hive table to mysql using sqoop?
Answer: Step1: Create a new database in the MySQL instance. CREATE DATABASE db1;
Create a table named acad.
Step3: Export the input.txt and input2.txt file from HDFS to MySQL. sqoop export –connect jdbc:mysql://localhost/db1 –username sqoop –password root –table acad –export-dir /sqoop_msql/ -m 1.