Apache Sqoop Cookbook: Unlocking Hadoop for Your Relational Database

Apache Sqoop Cookbook Unlocking Hadoop for Your Relational Database 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 Ap

  • Title: Apache Sqoop Cookbook: Unlocking Hadoop for Your Relational Database
  • Author: Kathleen Ting Jarek Jarcec Cecho
  • ISBN: 9781449364595
  • Page: 422
  • Format: ebook
  • 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 thisIntegrating 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 ecosystemKeep table data and Hadoop in sync by importing data incrementallyImport data from than one database tableCustomize transferred data by calling various database functionsExport generated, processed, or backed up data from Hadoop to your databaseRun Sqoop within Oozie, Hadoop s specialized workflow schedulerLoad data into Hadoop s data warehouse Hive or database HBase Handle installation, connection, and syntax issues common to specific database vendors

    One thought on “Apache Sqoop Cookbook: Unlocking Hadoop for Your Relational Database”

    1. Disclosure: I know Kathleen because we worked together fairly closely at Cloudera for a year or so.Disclosure: Further, through the use of my extremely good looks and Midwestern charm, I wheedled a free copy of this book from Kathleen when I bumped into her earlier this week. She didn't have a chance.This book is an excellent quick introduction for getting quickly up and running with Sqoop. There is a cursory section on installing it and grabbing the jdbc driver(s) then it's all about the vagari [...]

    2. Other than being a little weak on getting sqoop installed, really found the recipes in the book helpful and easy to follow.

    Leave a Reply

    Your email address will not be published. Required fields are marked *