4. Spark SQL | Spark Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Spark Cookbook

By : Yadav

4.4 (18)

Spark Cookbook

4.4 (18)

By: Yadav

Overview of this book

If you are a data engineer, an application developer, or a data scientist who would like to leverage the power of Apache Spark to get better insights from big data, then this is the book for you.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Apache Spark

1. Getting Started with Apache Spark

Introduction

Installing Spark from binaries

Building the Spark source code with Maven

Launching Spark on Amazon EC2

Deploying on a cluster in standalone mode

Deploying on a cluster with Mesos

Deploying on a cluster with YARN

Using Tachyon as an off-heap storage layer

2. Developing Applications with Spark

2. Developing Applications with Spark

Introduction

Exploring the Spark shell

Developing Spark applications in Eclipse with Maven

Developing Spark applications in Eclipse with SBT

Developing a Spark application in IntelliJ IDEA with Maven

Developing a Spark application in IntelliJ IDEA with SBT

3. External Data Sources

3. External Data Sources

Introduction

Loading data from the local filesystem

Loading data from HDFS

Loading data from HDFS using a custom InputFormat

Loading data from Amazon S3

Loading data from Apache Cassandra

Loading data from relational databases

4. Spark SQL

4. Spark SQL

Introduction

Understanding the Catalyst optimizer

Creating HiveContext

Inferring schema using case classes

Programmatically specifying the schema

Loading and saving data using the Parquet format

Loading and saving data using the JSON format

Loading and saving data from relational databases

Loading and saving data from an arbitrary source

5. Spark Streaming

5. Spark Streaming

Introduction

Word count using Streaming

Streaming Twitter data

Streaming using Kafka

6. Getting Started with Machine Learning Using MLlib

6. Getting Started with Machine Learning Using MLlib

Introduction

Creating vectors

Creating a labeled point

Creating matrices

Calculating summary statistics

Calculating correlation

Doing hypothesis testing

Creating machine learning pipelines using ML

7. Supervised Learning with MLlib – Regression

7. Supervised Learning with MLlib – Regression

Introduction

Using linear regression

Understanding cost function

Doing linear regression with lasso

Doing ridge regression

8. Supervised Learning with MLlib – Classification

8. Supervised Learning with MLlib – Classification

Introduction

Doing classification using logistic regression

Doing binary classification using SVM

Doing classification using decision trees

Doing classification using Random Forests

Doing classification using Gradient Boosted Trees

Doing classification with Naïve Bayes

9. Unsupervised Learning with MLlib

9. Unsupervised Learning with MLlib

Introduction

Clustering using k-means

Dimensionality reduction with principal component analysis

Dimensionality reduction with singular value decomposition

10. Recommender Systems

10. Recommender Systems

Introduction

Collaborative filtering using explicit feedback

Collaborative filtering using implicit feedback

11. Graph Processing Using GraphX

11. Graph Processing Using GraphX

Introduction

Fundamental operations on graphs

Using PageRank

Finding connected components

Performing neighborhood aggregation

12. Optimizations and Performance Tuning

12. Optimizations and Performance Tuning

Introduction

Optimizing memory

Using compression to improve performance

Using serialization to improve performance

Optimizing garbage collection

Optimizing the level of parallelism

Understanding the future of optimization – project Tungsten

Index

Index

Creating HiveContext

SQLContext and its descendant HiveContext are the two entry points into the world of Spark SQL. HiveContext provides a superset of functionality provided by SQLContext. The additional features are:

More complete and battle-tested HiveQL parser
Access to Hive UDFs
Ability to read data from Hive tables

From Spark 1.3 onwards, the Spark shell comes loaded with sqlContext (which is an instance of HiveContext not SQLContext). If you are creating SQLContext in Scala code, it can be created using SparkContext, as follows:

val sc: SparkContext
val sqlContext = new org.apache.spark.sql.SQLContext(sc)

In this recipe, we will cover how to create instance of HiveContext, and then access Hive functionality through Spark SQL.

Getting ready

To enable Hive functionality, make sure that you have Hive enabled (-Phive) assembly JAR is available on all worker nodes; also, copy hive-site.xml into the conf directory of the Spark installation. It is important that Spark has access to hive-site.xml...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Spark Cookbook

Search

Your notes and bookmarks