Sqoop export command in Big Data Hadoop
•Export data back from the HDFS to the RDBMS database.
•The target table must exist in the target database.
•The files which are given as input to the sqoop contain records, which are called rows in table. Those are read and parsed into a set of records and delimited with user-specified delimiter.
sqoop export --connect jdbc:mysql://localhost:3306/database --username --driver com.mysql.jdbc.Driver root --table tablename --export-dir /hadoopfolder/part-m-00000 --fields-terminated-by ',‘
•mysql>select * from tablename;
Post Your Comment