Data Transfer Using Sqoop
Sqoop is a powerful tool for importing and exporting data between Hadoop and relational databases. It allows for efficient provisioning of Hive Metastore, populating HBase tables, and utilizing various connectors for seamless data transfer. Learn about Sqoop's features, performance benchmarks, and how it facilitates efficient data migration in a cluster environment.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Sqoop Mr. Sriram Mr. Sriram Email: hadoopsrirama@gmail.com
Objectives What is Sqoop? Why Sqoop? Importing & Exporting Data using Sqoop Provisioning Hive Metastore Populating Hbase Tables Sqoop Connectors Sqoop Features Performance Benchmark in cluster for Sqoop
What is Sqoop? What is Sqoop? Why Sqoop? Why Sqoop? Importing & Exporting Data using Sqoop Importing & Exporting Data using Sqoop Provisioning Hive Metastore Provisioning Hive Metastore Populating Hbase Tables Populating Hbase Tables Sqoop Connectors Sqoop Connectors Sqoop Features Sqoop Features Performance Benchmark in cluster for Sqoop Performance Benchmark in cluster for Sqoop Sqoop Introduction Sqoop Introduction
Sqoop Intro Sqoop is a data transfer tool Sqoop transfer data between hadoop and relational DB servers Sqoop is used to import data from relational DB such as MySQL, Oracle Sqoop is used to export data from HDFS to relational DB Tools -> Sqoop Import / Export SQOOP Import Import individual tables from RDBMS to HDFS Each row in a table is treated as records in HDFS All record are stored as text data in text files or binary files SQOOP Export Export a set of files from HDFS back to RDBMS Files given an input to SQOOP contains records called as rows in table
