Weeks 4

Saprk SQL

Important

• Monday 02 February 2026 Halle 166E 10h45-12h45
• Calendar

Lecture : slides

We went through the first part (up to Aggregation) of - Spark high level APIs: SQL

We came back to section Pair RDD

• Spark RDD

Notebooks

We shall spend most of the lectures on

• Jupyter notebook V : Spark SQL
• html: Spark SQL

We did not touch Aggregation

You shall have gone through (on your own)

• Jupyter notebook I : tour of Python
• html: tour of Python
  
• Jupyter notebook II : tour of numpy
• html: tour of numpy
  
• Jupyter notebook III: tour of pandas
• html: tour of Pandas

References

• Spark Definitive Guide
• Spark
• Spark
• Data pipelines
• Next Generation Databases NoSQLand Big Data, Guy Harrison
• Mastering Spark on R

• Parquet
• ‘Arrow’
• Dask Docs
• Dask Examples
• Dask Code
• Dask Blog
• Pandas cheatsheet

Logistics

pyspark

To work the jupyter notebooks, install python 3, and modules related to jupyter: jupyter-cache, jupyter_client, jupyter_core, jupyterlab_widgets (this induces the installation of dependencies).

https://jupyter.org

Download the jupyter notebooks from notebooks listings.

If you do not already have an ENT account, follow instructions on Moodle to get one. You shall need this account to connect to PostGres cluster.

Back to Agenda ⏎