Apache Sqoop (discontinued)

Apache Sqoop is a discontinued open-source command-line tool for bulk data transfer between Apache Hadoop and structured data stores. It was commonly used to import relational database tables or mainframe datasets into HDFS for processing with Hadoop tools, then export processed data back to a relational database.

Sqoop used parallel MapReduce jobs for import and export operations. Its command suite supported full-table and query-based imports, incremental loads, configurable file formats and delimiters, generated Java classes for imported records, and integrations with Hadoop ecosystem tools such as Hive, HBase, and Accumulo. It also included utilities to inspect database schemas and tables, run SQL statements, save jobs, and merge imported datasets.

Apache Sqoop is no longer an active Apache project. It retired in June 2021 and was moved to the Apache Attic in July 2021; its site, source code, releases, and documentation are retained as read-only archives. Organizations still using Sqoop should treat it as legacy infrastructure and evaluate supported migration options for ongoing data movement and integration needs.