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 cookbooks problem-solution-discussion format, youll 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, Hadoops specialized workflow schedulerLoad data into Hadoops data warehouse (Hive) or database (HBase)Handle installation, connection, and syntax issues common to specific database vendors

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 cookbooks problem-solution-discussion format, youll 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, Hadoops specialized workflow schedulerLoad data into Hadoops data warehouse (Hive) or database (HBase)Handle installation, connection, and syntax issues common to specific database vendors