Book Image

Apache Spark 2.x Cookbook

By : Rishi Yadav
Book Image

Apache Spark 2.x Cookbook

By: Rishi Yadav

Overview of this book

While Apache Spark 1.x gained a lot of traction and adoption in the early years, Spark 2.x delivers notable improvements in the areas of API, schema awareness, Performance, Structured Streaming, and simplifying building blocks to build better, faster, smarter, and more accessible big data applications. This book uncovers all these features in the form of structured recipes to analyze and mature large and complex sets of data. Starting with installing and configuring Apache Spark with various cluster managers, you will learn to set up development environments. Further on, you will be introduced to working with RDDs, DataFrames and Datasets to operate on schema aware data, and real-time streaming with various sources such as Twitter Stream and Apache Kafka. You will also work through recipes on machine learning, including supervised learning, unsupervised learning & recommendation engines in Spark. Last but not least, the final few chapters delve deeper into the concepts of graph processing using GraphX, securing your implementations, cluster optimization, and troubleshooting.
Table of Contents (19 chapters)
Title Page
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Loading and saving data from relational databases


Loading data into Spark from relational databases is very common. As the Spark-based big data lake is becoming a replacement for traditional Enterprise Data warehouses, Spark needs to connect to support for JDBC.

Getting ready

Make sure that the JDBC driver JAR is visible on the client node and all the slave nodes on which the executor will run.

How to do it...

  1. Create a table named person in MySQL using the following DDL:
        CREATE TABLE 'person' ( 
          'person_id' int(11) NOT NULL AUTO_INCREMENT, 
          'first_name' varchar(30) DEFAULT NULL, 
          'last_name' varchar(30) DEFAULT NULL, 
          'gender' char(1) DEFAULT NULL, 
          'age' tinyint(4) DEFAULT NULL, 
          PRIMARY KEY ('person_id') 
        )
  1. Insert some data:
        Insert into person values('Barack','Obama','M',55); 
        Insert into person values('Bill','Clinton','M',70); 
        Insert into person values('Hillary','Clinton','F',69); 
        Insert...