Sqoop – Export
Exporting the data from HDFS to mysql
sqoop export –connect jdbc:mysql://localhost:3306/retail_db –username root –table test -P –export-dir /user/hello/datatomysql
the data is present in same folder and File name is Sqoop_data
firs the data should be present into the hdfs then u can export from the HDFS to partitular RDBMS Table.
RDBMS :=> mysql
Leave a Comment