Sqoop

Sqoop is a command-line interface application for transferring data between relational databases and Hadoop.^[1] 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.^[2] Exports can be used to put data from Hadoop into a relational database. Sqoop became a top-level Apache project in March 2012.^[3]

Microsoft uses a Sqoop-based connector to help transfer data from Microsoft SQL Server databases to Hadoop.^[4] Couchbase, Inc. also provides a Couchbase Server-Hadoop connector by means of Sqoop.^[5]

See also

• Hive
• Accumulo
• HBase

References

Bibliography

External links

• Official website
• Sqoop Wiki
• Sqoop Users Mailing List Archives

Apache Software Foundation Top level projects Abdera Accumulo ActiveMQ Ant Aries Apache HTTP Server APR Avro Axis Axis2 Bloodhound Buildr Camel Cassandra Cayenne Chemistry Click CloudStack Cocoon Continuum Cordova CouchDB cTAKES CXF Deltacloud Derby Directory Empire-db Felix Flex Forrest Geronimo Gora Gump Hadoop Hama HBase Hive Isis Jackrabbit James JMeter Kafka Lenya Mahout Marmotta Maven MINA mod_perl MyFaces ODE OFBiz OpenEJB OpenJPA OpenNLP OpenOffice PDFBox Phoenix POI Pivot Qpid River Roller Samza ServiceMix Shindig Shiro Sling Spark Stanbol Storm SpamAssassin Struts Subversion Sqoop Tapestry Tcl Thrift Tiles Tomcat Trafficserver Turbine Tuscany UIMA Velocity Wave Wicket Wink Xalan Xerces XMLBeans Commons Projects BCEL BSF Daemon Jelly Lucene Projects Lucene Java Lucene.Net Nutch Solr Hadoop Projects HDFS HBase Hive Pig Spark ZooKeeper Other projects Chainsaw Batik FOP Log4j XAP Log4Net Ivy Incubator Projects XAP Apache Attic AxKit Beehive Bluesky Cactus Jakarta Excalibur Harmony HiveMind Slide Shale stdcxx iBATIS Licenses standards Apache License Category Commons