Free Downloads
Apache Sqoop Cookbook

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

File Size: 268 KB

Print Length: 94 pages

Simultaneous Device Usage: Unlimited

Publisher: O'Reilly Media; 1 edition (July 2, 2013)

Publication Date: July 2, 2013

Sold by:  Digital Services LLC

Language: English


Text-to-Speech: Enabled

X-Ray: Not Enabled

Word Wise: Not Enabled

Lending: Not Enabled

Enhanced Typesetting: Not Enabled

Best Sellers Rank: #719,876 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #69 in Books > Computers & Technology > Databases & Big Data > Relational Databases #502 in Books > Computers & Technology > Networking & Cloud Computing > Network Administration > Storage & Retrieval #713 in Kindle Store > Kindle eBooks > Computers & Technology > Databases

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.

TOC looks good. However, the main question now is whether this book is updated for Sqoop2 - a major architectural re-design. For starter, client-side installation is eliminated. Connectors are also moved away from the JDBC paradigm. Given that the author is an insider, and Sqoop2 was well near GA in 2012 (the author herself blogged about it in Jan, 2012 -, one would expect so. However, the book blurb and extracts give no indication at all.If the book is Sqoop2-compliant, I will buy it. If not, then not. Not knowing this, I can only give 3 stars as a compromise.

This book was very helpful when I needed to import data from MySQL into a S3-backed Hive data warehouse using an Oozie workflow, lots of the little recipes helped to get my job done way quicker than I would've imagined. I definitely recommend anyone interested in bulk loading data from a relational database into the Hadoop world to get this book.

Apache Sqoop Cookbook Apache Cookbook: Solutions and Examples for Apache Administrators Apache Hadoop YARN: Moving beyond MapReduce and Batch Processing with Apache Hadoop 2 (Addison-Wesley Data & Analytics) Apache Hadoop YARN: Moving beyond MapReduce and Batch Processing with Apache Hadoop 2 (Addison-Wesley Data & Analytics Series) Apache Cordova API Cookbook (Mobile Programming) Apache Spark in 24 Hours, Sams Teach Yourself NoSQL Web Development with Apache Cassandra Apache: The Definitive Guide (3rd Edition) Hadoop 2 Quick-Start Guide: Learn the Essentials of Big Data Computing in the Apache Hadoop 2 Ecosystem (Addison-Wesley Data & Analytics) Hadoop 2 Quick-Start Guide: Learn the Essentials of Big Data Computing in the Apache Hadoop 2 Ecosystem (Addison-Wesley Data & Analytics Series) Apache Solr: A Practical Approach to Enterprise Search Linux, Apache, MySQL, PHP Performance End to End Linux Apache Web Server Administration, Second Edition (Craig Hunt Linux Library) Apache Country Crock Pot: Everyday Crock Pot and Slow Cooker Recipes for Beginners(Slow Cooker, Slow Cooker Cookbook, Slow Cooker, Slow Cooker Cookbook, Crockpot Cookbook, ... Low Carb ) (Cookbook delicious recipes 1) Island Style Cookbook: Guam's Favorite Soups, Tasty Guam Recipes, Wonderful Chamorro Island Food , Exotic Guam Cookbook Of Soups, Enjoy Awesome Chamorro Guam Food From This Island Cookbook Easy Vietnamese Cookbook: 50 Authentic Vietnamese Recipes (Vietnamese Recipes, Vietnamese Cookbook, Vietnamese Cooking, Easy Vietnamese Cookbook, Easy Vietnamese Recipes, Vietnamese Food Book 1) Chinese Cooking: No Wok Takeout! 80 Amazingly Delicious 3 Steps Or Less Chinese Recipes Revealed (Chinese Cookbook, Cooking For One) (cookbook for beginners, ... meals cookbook, easy meals for one 2) Crockpot Recipes: 30 Delicious, Dairy & Gluten Free, Low Carb Recipes For Busy People (Slow Cooker, Slow Cooker Cookbook, Crockpot Cookbook, Gluten Free ... Cooker Recipes, Low Carb Cookbook Book 1) Easy Tomato Sauce Cookbook: 50 Delicious Tomato Sauce Recipes (Tomato Sauce, Tomato Sauce Cookbook, Tomato Sauce Recipes, Italian Cookbook, Italian Recipes Book 1)