Sqoop – Export

Estimated reading: 1 minute 371 views

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

CONTENTS