Sqoop

Apache Sqoop is a command-line interface application for transferring data between relational databases and Hadoop. It supports incremental loads of a single table or a free form SQL query as well as saved jobs which can be run multiple times to import updates made to a database since the last import. Imports can also be used to populate tables in Hive or HBase. Exports can be used to put data from Hadoop into a relational database. Sqoop got the name from sql+hadoop. Sqoop became a top-Apache Sqoop is a command-line interface application for transferring data between relational databases and Hadoop. It supports incremental loads of a single table or a free form SQL query as well as saved jobs which can be run multiple times to import updates made to a database since the last import. Imports can also be used to populate tables in Hive or HBase. Exports can be used to put data from Hadoop into a relational database. Sqoop got the name from sql+hadoop. Sqoop became a top-level Apache project in March 2012.level Apache project in March 2012.

Sqoop Study

  1. sqoop-installation
  2. sqoop-import-from-mysql-database-data-to-hdfs
  3. sqoop-export-to-mysql-database-from-hdfs
  4. sqoop-job-command-with-example
  5. sqoop-codegen-command-with-example
  6. sqoop-eval-command-with-example
  7. sqoop-list-databases-command-with-example
  8. sqoop-list-tables-command-with-example