Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Apache Spark 2.x Cookbook

You're reading from  Apache Spark 2.x Cookbook

Product type Book
Published in May 2017
Publisher
ISBN-13 9781787127265
Pages 294 pages
Edition 1st Edition
Languages
Author (1):
Rishi Yadav Rishi Yadav
Profile icon Rishi Yadav

Table of Contents (19) Chapters

Title Page
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
Getting Started with Apache Spark Developing Applications with Spark Spark SQL Working with External Data Sources Spark Streaming Getting Started with Machine Learning Supervised Learning with MLlib — Regression Supervised Learning with MLlib — Classification Unsupervised Learning Recommendations Using Collaborative Filtering Graph Processing Using GraphX and GraphFrames Optimizations and Performance Tuning

Understanding joins


A SQL join is a process of combining two datasets based on a common column. Joins come in really handy for extracting extra values by combining multiple tables. 

Getting ready

We are going to use Yelp data as part of this recipe, which is provided by Yelp for Yelp Data Challenge. The data is divided into the following six files:

  • yelp_academic_dataset_business.json
  • yelp_academic_dataset_review.json
  • yelp_academic_dataset_user.json
  • yelp_academic_dataset_checkin.json
  • yelp_academic_dataset_tip.json
  • photos (from the photos auxiliary file)

We are going to use this data for multiple purposes across the book. This data really works for this recipe as it has joins everywhere. 

Note

This data is already loaded in the s3a://sparkcookbook/yelpdata Amazon S3 bucket for your convenience. Spark provides a convenient way to access S3 using the S3a prefix. This is not the standard way to access S3 buckets though. S3 buckets are accessed using HTTP URL. There are a few ways to specify the URL. For...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}