---
title: Sqoop
slug: sqoop
qid: 
snapshot: enwiki-001333602511
content_hash: 
license: CC BY-SA 4.0
source: https://en.wikipedia.org/w/index.php?oldid=1333602511
tags: [114935324, 23118434, 23603337, 24165216, 25579858, 99520060]
---

# Sqoop

> [!note] Provenance
> Snapshot `enwiki-001333602511` · content root `…`
> Derived from <https://en.wikipedia.org/w/index.php?oldid=1333602511> · Licensed CC BY-SA 4.0

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.

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. ==See also== Apache Hadoop Apache Hive Apache Accumulo Apache HBase ==References== ==Bibliography== ==External links== Sqoop Wiki Sqoop Users Mailing List Archives
