Sqoop

---

title: "Sqoop" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["apache-attic", "cloud-applications", "apache-hadoop", "software-using-the-apache-license"] description: "Data management application" topic_path: "general/apache-attic" source: "https://en.wikipedia.org/wiki/Sqoop" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

::summary Data management application ::

::data[format=table title="Infobox software"]

Field	Value
name	Apache Sqoop
logo	Apache Sqoop logo.svg
released
developer	Apache Software Foundation
discontinued	yes
latest release version	1.4.7
latest release date
operating system	Cross-platform
repo
programming language	Java
genre	Data management
license	Apache License 2.0
website
::

| name = Apache Sqoop | logo = Apache Sqoop logo.svg | released =
| screenshot = | caption = | developer = Apache Software Foundation | discontinued = yes | latest release version = 1.4.7 | latest release date = | latest preview version = | latest preview date = | operating system = Cross-platform | repo = | programming language = Java | genre = Data management | license = Apache License 2.0 | website = Sqoop is a command-line interface application for transferring data between relational databases and Hadoop.

The Apache Sqoop project was retired in June 2021 and moved to the Apache Attic.

Description

Sqoop 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-to-Hadoop". Sqoop became a top-level Apache project in March 2012.

Informatica provides a Sqoop-based connector from version 10.1. Pentaho provides open-source Sqoop based connector steps, Sqoop Import and Sqoop Export, in their ETL suite Pentaho Data Integration since version 4.5 of the software. Microsoft uses a Sqoop-based connector to help transfer data from Microsoft SQL Server databases to Hadoop. Couchbase, Inc. also provides a Couchbase Server-Hadoop connector by means of Sqoop.

References

Bibliography

• {{Cite book |first1 = Tom |last1 = White |title = Hadoop: The Definitive Guide |edition = 2nd |chapter = Chapter 15: Sqoop |year = 2010 |publisher = O'Reilly Media |pages = 477–495 |isbn = 978-1-449-38973-4 |chapter-url = https://archive.org/details/hadoopdefinitive0000whit/page/477

References

1. "Hadoop: Apache Sqoop".
2. "moving Sqoop to the Attic".
3. "Apache Sqoop - Overview".
4. "Introducing Sqoop".
5. "Apache Sqoop Graduates from Incubator".
6. "Microsoft SQL Server Connector for Apache Hadoop".
7. "Couchbase Hadoop Connector".

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::