Apache Sqoop Cookbook

Unlocking Hadoop for Your Relational Database

Nonfiction, Computers, Database Management
Cover of the book Apache Sqoop Cookbook by Kathleen Ting, Jarek Jarcec Cecho, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Kathleen Ting, Jarek Jarcec Cecho ISBN: 9781449364588
Publisher: O'Reilly Media Publication: July 2, 2013
Imprint: O'Reilly Media Language: English
Author: Kathleen Ting, Jarek Jarcec Cecho
ISBN: 9781449364588
Publisher: O'Reilly Media
Publication: July 2, 2013
Imprint: O'Reilly Media
Language: English

Integrating data from multiple sources is essential in the age of big data, but it can be a challenging and time-consuming task. This handy cookbook provides dozens of ready-to-use recipes for using Apache Sqoop, the command-line interface application that optimizes data transfers between relational databases and Hadoop.

Sqoop is both powerful and bewildering, but with this cookbook’s problem-solution-discussion format, you’ll quickly learn how to deploy and then apply Sqoop in your environment. The authors provide MySQL, Oracle, and PostgreSQL database examples on GitHub that you can easily adapt for SQL Server, Netezza, Teradata, or other relational systems.

  • Transfer data from a single database table into your Hadoop ecosystem
  • Keep table data and Hadoop in sync by importing data incrementally
  • Import data from more than one database table
  • Customize transferred data by calling various database functions
  • Export generated, processed, or backed-up data from Hadoop to your database
  • Run Sqoop within Oozie, Hadoop’s specialized workflow scheduler
  • Load data into Hadoop’s data warehouse (Hive) or database (HBase)
  • Handle installation, connection, and syntax issues common to specific database vendors
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Integrating data from multiple sources is essential in the age of big data, but it can be a challenging and time-consuming task. This handy cookbook provides dozens of ready-to-use recipes for using Apache Sqoop, the command-line interface application that optimizes data transfers between relational databases and Hadoop.

Sqoop is both powerful and bewildering, but with this cookbook’s problem-solution-discussion format, you’ll quickly learn how to deploy and then apply Sqoop in your environment. The authors provide MySQL, Oracle, and PostgreSQL database examples on GitHub that you can easily adapt for SQL Server, Netezza, Teradata, or other relational systems.

More books from O'Reilly Media

Cover of the book You Don't Know JS: ES6 & Beyond by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Learning from First Responders: When Your Systems Have to Work by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book C# 3.0 Design Patterns by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Network Security with OpenSSL by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Big Book of Apple Hacks by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Mastering Perl by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book SQL Pocket Guide by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Mono: A Developer's Notebook by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Home Networking Annoyances by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book JUNOS High Availability by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Exchange Server Cookbook by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book SharePoint Apps with LightSwitch by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book XML Schema by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book Creating Keynote Slideshows: The Mini Missing Manual by Kathleen Ting, Jarek Jarcec Cecho
Cover of the book ActionScript 3.0 Cookbook by Kathleen Ting, Jarek Jarcec Cecho
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy