Working with PySpark SQL Tables and Views | Managed vs Unmanaged Tables

Published: 10 March 2023
on channel: AmpCode
5,582
78

In this lecture, we're going to learn all about Apache Spark/ PySpark SQL Tables and Views where we will discuss about what are managed vs unmanaged tables in PySpark SQL as well difference between Spark SQL Views and Tables as well as Temporary views and Global Temp Views in PySpark along with hands on tutorial.

Data file: https://github.com/ashaypatil11/spark...

PySpark Jupyter Notebook: https://github.com/ashaypatil11/spark...

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

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

PySpark installation steps on MAC: https://sparkbyexamples.com/pyspark/h...

Apache Spark Installation links:

1. Download JDK: https://www.oracle.com/in/java/techno...

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:
   • Big Data Hadoop Full Course  

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

1. Download JDK: https://www.oracle.com/in/java/techno...

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:    • What is Big Data? | Big Data Use Case...  

How Cloud Computing changed the world:    • How Cloud Computing changed the world!  

What is Cloud?    • What is Cloud Computing?  

Top 10 facts about Cloud Computing that will blow your mind!    • Top 10 facts about Cloud Computing th...  

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-
   • SQL Full Course  


PYTHON Full Course Playlist-
   • Python Full Course  

Data Warehouse Playlist-
   • Data Warehouse Full Course  


Unix Shell Scripting Full Course Playlist-
   • Unix Shell Scripting Full Course  

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

Facebook-
  / ampcode  

Instagram-
  / ampcode_tutorials  

Twitter-
  / 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


Watch video Working with PySpark SQL Tables and Views | Managed vs Unmanaged Tables online without registration, duration hours minute second in high quality. This video was added by user AmpCode 10 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,582 once and liked it 78 people.