What do you think?
Rate this book
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 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 more 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
94 pages, Kindle Edition
First published January 1, 2013
3 people are currently reading
23 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
October 10, 2013
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 vagaries of moving data back and forth between HDFS and your RDBMS.
Personally I like the structure of the book. Each "recipe" in the cookbook states a problem, then states the solution (with a working example), then there is a brief discussion explaining why and how this solution works. Most of these sections build on the previous examples.
So by reading it in order you get a very logical and step-by-step understanding of how Sqoop works along with at least one working example for each step. You could work through the examples on your laptop (code is on Github) as you go through the book for a deeper understanding.
It is also possible to use this book by finding your problem in the table of contents and flipping right to that section.
Other people may have different styles of learning, so for them there is the documentation on the Apache site or the section in Hadoop: The Definitive Guide on Sqoop. But with the Hadoop ecosystem I find that so much of getting it to work is trial and error, so having practical working examples is worth the price of the book.
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 vagaries of moving data back and forth between HDFS and your RDBMS.
Personally I like the structure of the book. Each "recipe" in the cookbook states a problem, then states the solution (with a working example), then there is a brief discussion explaining why and how this solution works. Most of these sections build on the previous examples.
So by reading it in order you get a very logical and step-by-step understanding of how Sqoop works along with at least one working example for each step. You could work through the examples on your laptop (code is on Github) as you go through the book for a deeper understanding.
It is also possible to use this book by finding your problem in the table of contents and flipping right to that section.
Other people may have different styles of learning, so for them there is the documentation on the Apache site or the section in Hadoop: The Definitive Guide on Sqoop. But with the Hadoop ecosystem I find that so much of getting it to work is trial and error, so having practical working examples is worth the price of the book.
August 26, 2013
Other than being a little weak on getting sqoop installed, really found the recipes in the book helpful and easy to follow.
Displaying 1 - 2 of 2 reviews