The goal of this post is to give an overview of Sqoop operation without going into much detail or advanced functionality. In the rest of this post we will walk through an example that shows the various ways you can use Sqoop. Each record of the data is handled in a type safe manner since Sqoop uses the database metadata to infer the data types. The dataset being transferred is sliced up into different partitions and a map-only job is launched with individual mappers responsible for transferring a slice of this dataset. What happens underneath the covers when you run Sqoop is very straightforward. Sqoop uses a connector based architecture which supports plugins that provide connectivity to new external systems. Sqoop integrates with Oozie, allowing you to schedule and automate import and export tasks. Using Sqoop, you can provision the data from external system on to HDFS, and populate tables in Hive and HBase. Sqoop allows easy import and export of data from structured data stores such as relational databases, enterprise data warehouses, and NoSQL systems. More information on this project can be found at.

Apache Sqoop is currently undergoing incubation at Apache Software Foundation. Directly accessing data residing on external systems from within the map reduce applications complicates applications and exposes the production system to the risk of excessive load originating from cluster nodes. Transferring data using scripts is inefficient and time consuming. Users must consider details like ensuring consistency of data, the consumption of production system resources, data preparation for provisioning downstream pipeline.

Loading bulk data into Hadoop from production systems or accessing it from map reduce applications running on large clusters can be a challenging task. Using Hadoop for analytics and data processing requires loading data into clusters and processing it in conjunction with other data that often resides in production databases across the enterprise.

Cara bikin aplikasi tuman