Apache Spark: Working with external data sources | PySpark Tutorial | Lecture 10

In this lecture, we're going to learn all about how to work with external data sources in Apache Spark(PySpark) where we will learn about user-defined functions and how to implement them and ways to integrate Apache PySpark with external databases like RDBMS(SQL Server, MySQL, Postgre etc) as well as NoSQL databases like MongoDB and Cassandra.

PySpark Jupyter Notebook: https://github.com/ashaypatil11/spark/blob/main/sparkSQL.ipynb

Anaconda Distributions Installation link:
https://www.anaconda.com/products/distribution

----------------------------------------------------------------------------------------------------------------------

PySpark installation steps on MAC: https://sparkbyexamples.com/pyspark/how-to-install-pyspark-on-mac/

Apache Spark Installation links:

1. Download JDK: https://www.oracle.com/in/java/technologies/downloads/#jdk19-windows

2. Download Python: https://www.python.org/downloads/

3. Download Spark: https://spark.apache.org/downloads.html

Environment Variables:

HADOOP_HOME- C:\hadoop
JAVA_HOME- C:\java\jdk
SPARK_HOME- C:\spark\spark-3.3.1-bin-hadoop2
PYTHONPATH- %SPARK_HOME%\python;%SPARK_HOME%\python\lib\py4j-0.10.9-src;%PYTHONPATH%

Required Paths:

%SPARK_HOME%\bin
%HADOOP_HOME%\bin
%JAVA_HOME%\bin

Also check out our full Apache Hadoop course:
https://youtube.com/playlist?list=PL6UwySlcwEYJ2hFuGIvr4VEHUAfl-GCNT

----------------------------------------------------------------------------------------------------------------------
Apache Spark Installation links:

1. Download JDK: https://www.oracle.com/in/java/technologies/downloads/#jdk19-windows

2. Download Python: https://www.python.org/downloads/

3. Download Spark: https://spark.apache.org/downloads.html

-------------------------------------------------------------------------------------------------------------

Also check out similar informative videos in the field of cloud computing:

What is Big Data: https://youtu.be/-BoykjY5nKg

How Cloud Computing changed the world: https://youtu.be/lf2lQAyW2b4

What is Cloud? https://youtu.be/DeCMeA9Xm2g

Top 10 facts about Cloud Computing that will blow your mind! https://youtu.be/hmxNJEQ4XVY

Audience

This tutorial has been prepared for professionals/students aspiring to learn deep knowledge of Big Data Analytics using Apache Spark and become a Spark Developer and Data Engineer roles. In addition, it would be useful for Analytics Professionals and ETL developers as well.

Prerequisites

Before proceeding with this full course, it is good to have prior exposure to Python programming, database concepts, and any of the Linux operating system flavors.

-----------------------------------------------------------------------------------------------------------------------

Check out our full course topic wise playlist on some of the most popular technologies:

SQL Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYISVLQlYi3W6rGCIo9sJM0J


PYTHON Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYJgM4eUQOvR1KAWryFYcclq

Data Warehouse Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYKxi-fQHLkVYDZrJcBawZA9


Unix Shell Scripting Full Course Playlist-
https://youtube.com/playlist?list=PL6UwySlcwEYIZGsbXnUxsojD0yeUA67lb

-----------------------------------------------------------------------------------------------------------------------Don't forget to like and follow us on our social media accounts:

Facebook-
https://www.facebook.com/ampcode

Instagram-
https://www.instagram.com/ampcode_tutorials/

Twitter-
https://twitter.com/ampcodetutorial

Tumblr-
ampcode.tumblr.com

-----------------------------------------------------------------------------------------------------------------------

Channel Description-

AmpCode provides you e-learning platform with a mission of making education accessible to every student. AmpCode will provide you tutorials, full courses of some of the best technologies in the world today. By subscribing to this channel, you will never miss out on high quality videos on trending topics in the areas of Big Data & Hadoop, DevOps, Machine Learning, Artificial Intelligence, Angular, Data Science, Apache Spark, Python, Selenium, Tableau, AWS , Digital Marketing and many more.

#pyspark #bigdata #datascience #dataanalytics #datascientist #spark #dataengineering #apachespark