imported>Taeas：维护清理

2023-08-01T13:13:26Z

维护清理

新页面

{{Infobox software
| name = Apache Sqoop
| logo = Apache Sqoop logo.svg
| screenshot =
| caption =
| developer = [[Apache Software Foundation]]
| released = {{Start date and age|2009|06|01|df=yes}} 
| discontinued = yes
| programming language = [[Java]]
| operating system = [[跨平台]]
| genre = [[数据管理]]
| license = [[Apache License 2.0]]
| repo = {{URL|https://gitbox.apache.org/repos/asf?p=sqoop.git|Sqoop Repository}}
| website = {{URL|https://sqoop.apache.org}}
}}
'''Apache Sqoop'''是用于在[[关系型数据库]]和[[Apache Hadoop|Hadoop]]之间传输数据的开源工具。<ref>{{Cite web |title=Sqoop - |url=https://sqoop.apache.org/ |website=sqoop.apache.org |access-date=2022-06-24 |archive-date=2022-07-07 |archive-url=https://web.archive.org/web/20220707224939/https://sqoop.apache.org/ |dead-url=no }}</ref> 该项目始于2009年，在2021年6月结束，并被移至[[Apache Attic]]。<ref>{{Cite web |title=moving Sqoop to the Attic |url=http://mail-archives.apache.org/mod_mbox/sqoop-user/202106.mbox/browser |url-status=no |website=mail-archives.apache.org |access-date=2021-06-27 |archive-date=2021-06-27 |archive-url=https://web.archive.org/web/20210627201658/http://mail-archives.apache.org/mod_mbox/sqoop-user/202106.mbox/browser }}</ref>

== 概要 ==
Sqoop支持增量更新，将新记录添加到最近一次的导出的数据源上，或者指定上次修改的时间戳。导入也可以填充[[Apache Hive|Hive]]或[[Apache HBase|HBase]]中的表。<ref>{{Cite web |title=Apache Sqoop - Overview : Apache Sqoop |url=https://blogs.apache.org/sqoop/entry/apache_sqoop_overview |website=blogs.apache.org |access-date=2022-06-24 |archive-date=2022-06-24 |archive-url=https://web.archive.org/web/20220624141140/https://blogs.apache.org/sqoop/entry/apache_sqoop_overview |dead-url=no }}</ref> 导出则支持将Hadoop的数据放入关系数据库中。Sqoop得名于“SQL-to-Hadoop”。Sqoop于2012年3月成为顶级Apache项目。<ref>{{Cite web |title=Apache Sqoop Graduates from Incubator : Apache Sqoop |url=https://blogs.apache.org/sqoop/entry/apache_sqoop_graduates_from_incubator |website=blogs.apache.org |access-date=2022-06-24 |archive-date=2022-06-24 |archive-url=https://web.archive.org/web/20220624141045/https://blogs.apache.org/sqoop/entry/apache_sqoop_graduates_from_incubator |dead-url=no }}</ref>

Informatica从10.1版开始提供基于Sqoop的连接器。Pentaho自4.5版开始在其[[ETL]]套件Pentaho Data Integration中提供基于开源Sqoop的连接器，Sqoop导入<ref name="2015-12-10_PSI" />和导出<ref name="2015-12-10_PSE" />。<ref name="2012-07-27_dbta" />[[微软]]使用基于Sqoop的连接器将数据从[[Microsoft SQL Server]]传输到Hadoop。<ref>{{cite web |title=Microsoft SQL Server Connector for Apache Hadoop |url=https://www.microsoft.com/en-us/download/details.aspx?id=27584 |access-date=Sep 8, 2012 |archive-date=2016-04-13 |archive-url=https://web.archive.org/web/20160413023204/http://www.microsoft.com/en-us/download/details.aspx?id=27584 |dead-url=no }}</ref>Couchbase还通过Sqoop提供Couchbase Server-Hadoop连接器。<ref>{{cite web |title=Couchbase Hadoop Connector |url=http://www.couchbase.com/develop/connectors/hadoop |url-status=dead |archive-url=https://web.archive.org/web/20120825184036/http://www.couchbase.com/develop/connectors/hadoop |archive-date=2012-08-25 |access-date=Sep 8, 2012}}</ref>

== 参考书目 ==
{{Refbegin}}
*{{Cite book|first1=Tom|last1=White|title=Hadoop: The Definitive Guide|edition=2nd|chapter=Chapter 15: Sqoop|publisher=[[O'Reilly Media]]|pages=[https://archive.org/details/hadoopdefinitive0000whit/page/477 477–495]|isbn=978-1-449-38973-4|url=https://archive.org/details/hadoopdefinitive0000whit/page/477}}
{{Refend}}

== 参考资料 ==
{{Reflist|refs=<ref name="2012-07-27_dbta">{{cite web
| url = http://www.dbta.com/Editorial/News-Flashes/Big-Data-Analytics-Vendor-Pentaho-Announces-Tighter-Integration-with-Cloudera-Extends-Visual-Interface-to-Include-Hadoop-Sqoop-and-Oozie-84025.aspx
| title = Big Data Analytics Vendor Pentaho Announces Tighter Integration with Cloudera; Extends Visual Interface to Include Hadoop Sqoop and Oozie
| publisher = Database Trends and Applications (dbta.com)
| date = 2012-07-27
| access-date = 2015-12-08
| archive-url = https://web.archive.org/web/20151208144234/http://www.dbta.com/Editorial/News-Flashes/Big-Data-Analytics-Vendor-Pentaho-Announces-Tighter-Integration-with-Cloudera-Extends-Visual-Interface-to-Include-Hadoop-Sqoop-and-Oozie-84025.aspx
| archive-date = 2015-12-08
| quote = 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.
}}</ref>

<ref name="2015-12-10_PSE">{{cite web
| url = http://wiki.pentaho.com/display/EAI/Sqoop+Export
| title = Sqoop Export
| publisher = Pentaho
| date = 2015-12-10
| access-date = 2015-12-10
| archive-url = https://web.archive.org/web/20151210171525/http://wiki.pentaho.com/display/EAI/Sqoop+Export
| archive-date = 2015-12-10
| quote = The Sqoop Export job allows you to export data from Hadoop into an RDBMS using Apache Sqoop.
}}</ref>

<ref name="2015-12-10_PSI">{{cite web
| url = http://wiki.pentaho.com/display/EAI/Sqoop+Import
| title = Sqoop Import
| publisher = Pentaho
| date = 2015-12-10
| access-date = 2015-12-10
| archive-url = https://web.archive.org/web/20151210170913/http://wiki.pentaho.com/display/EAI/Sqoop+Import
| archive-date = 2015-12-10
| quote = The Sqoop Import job allows you to import data from a relational database into the Hadoop Distributed File System (HDFS) using Apache Sqoop.
}}</ref>}}
<references />

{{Apache Software Foundation}}

[[Category:Apache软件基金会项目]]
[[Category:雲端運算]]
[[Category:Hadoop]]

Apache Sqoop - 版本历史

imported>Taeas：​维护清理

imported>Taeas：维护清理