Sqoop

Sqoop is used to transfer data between relational databases and HDFS. A sqoop job is decomposed into a map reduce job. The sqoop map-reduce job makes a jdbc connection to the database and retrives data for import. To avoid problems such as Denial of service on RDBMS, sqoop caps the number of mappers and the default is 4. Using sqoop, we can import/export single table or multiple tables from/to the database.