WHAT IS SQOOP

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.[3]?Exports can be used to put data from Hadoop into a relational database. Sqoop got the name from "SQL-to-Hadoop".[4]?Sqoop became a top-level?Apache?project in March 2012.[5]

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

See also[edit]

• Apache Hadoop
• Apache Hive
• Apache Accumulo
• Apache HBase

References[edit]

1. ^?"Hadoop: Apache Sqoop". Retrieved?Sep 8,?2012.
2. ^?"moving Sqoop to the Attic".?mail-archives.apache.org. Retrieved?2021-06-27.
3. ^?"Apache Sqoop - Overview". Retrieved?Sep 8,?2012.
4. ^?"Introducing Sqoop". Retrieved?Jan 1,?2019.
5. ^?"Apache Sqoop Graduates from Incubator". Retrieved?Sep 8,?2012.
6. ^?"Sqoop Import".?Pentaho. 2015-12-10. Archived from?the original?on 2015-12-10. Retrieved?2015-12-10.?The Sqoop Import job allows you to import data from a relational database into the Hadoop Distributed File System (HDFS) using Apache Sqoop.
7. ^?"Sqoop Export".?Pentaho. 2015-12-10. Archived from?the original?on 2015-12-10. Retrieved?2015-12-10.?The Sqoop Export job allows you to export data from Hadoop into an RDBMS using Apache Sqoop.
8. ^?"Big Data Analytics Vendor Pentaho Announces Tighter Integration with Cloudera; Extends Visual Interface to Include Hadoop Sqoop and Oozie".?Database Trends and Applications?(dbta.com). 2012-07-27. Archived from?the original?on 2015-12-08. Retrieved?2015-12-08.?Pentaho's Business Analytics 4.5 is now certified on Cloudera's latest releases, Cloudera Enterprise 4.0 and CDH4. Pentaho also announced that its visual design studio capabilities have been extended to the Sqoop and Oozie components of Hadoop.
9. ^?"Microsoft SQL Server Connector for Apache Hadoop".?Microsoft. Retrieved?Sep 8,?2012.
10. ^?"Couchbase Hadoop Connector". Archived from?the original?on 2012-08-25. Retrieved?Sep 8,?2012.

Bibliography[edit]

• White, Tom (2010).?"Chapter 15: Sqoop".?Hadoop: The Definitive Guide?(2nd?ed.).?O'Reilly Media. pp.?477–495.?ISBN?978-1-449-38973-4.

External links[edit]

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

hide

vte

The Apache Software Foundation

Top-level

• projectsAccumuloActiveMQAGEAirflowAmbariAntAriesArrowApache HTTP ServerAPRAvroAxisAxis2BeamBloodhoundBrooklynBuildrCalciteCamelCarbonDataCassandraCayenneChemistryCloudStackCocoonCordovaCouchDBcTAKESCXFDerbyDirectoryDrillDruidEmpire-dbFelixFlexFlinkFlumeFreeMarkerGeronimoGiraphGumpHadoopHBaseHelixHiveImpalaJackrabbitJamesJenaJiniJMeterKafkaKuduKylinLuceneMahoutMavenMINAmod_perlMyFacesNiFiNetBeansNutchOFBizOozieOpenEJBOpenJPAOpenNLPOрenOfficeORCPDFBoxParquetPhoenixPOIPigPinotPivotQpidRollerRocketMQSamzaServiceMixShiroSINGASlingSolrSparkStormSpamAssassinStruts 1Struts 2SubversionSupersetSystemDSTapestryThriftTikaTomcatTrafodionTraffic ServerUIMAVelocityWicketXalanXercesXMLBeansYetusZooKeeper
• CommonsBCELBSFDaemonJellyLogging
• IncubatorMXNetNuttXTaverna
• Other projectsBatikChainsawFOPIvyLog4j
• AtticAbderaApexAxKitBeehiveBlueskyiBATISC++ Standard LibraryCactusClickContinuumDeltacloudEtchExcaliburForrestHamaHarmonyHiveMindJakartaLenyaMarmottaODEShaleShindigSlideSqoopStanbolTuscanyWaveWinkXML
• LicensesApache License
• ?Category

Categories:?Apache Software Foundation projectsCloud applicationsHadoop

• This page was last edited on 30 March 2023, at 18:19?(UTC).