list sqoop jobs Archives - Hadoop Online Tutorials

Sqoop Export Commands 1

This entry was posted in Sqoop and tagged apache sqoop installation guide apache sqoop installation on ubuntu cannot create an instance of inputformat class org.apache.hadoop.mapred.textinputformat delete sqoop job inspect sqoop job list sqoop jobs sqoop import all tables example sqoop import hive sqoop import merge example sqoop merge on February 27, 2015 by ravi

Below are some Sqoop Export Commands and Other Miscellaneous commands Sqoop-export It is nothing but exporting data from HDFS to database. To use ‘export‘ command, a table in database should already exist. then only export functionality in sqoop will works. export command will works in two ways 1. insert 2. update 1. insert: insert mode will insert the new records from HDFS to RDBMS table. command:


sqoop export --connect jdbc:mysql://localhost/sqoop_export --table student_exported --export-dir /sqoop/newstudent/part-m-00000

1 2	sqoop export --connect jdbc:mysql://localhost/sqoop_export --table student_exported --export-dir /sqoop/newstudent/part-m-00000

Note: if a […]