Weeks 6

Spark SQL/RDD

Important

2 Sessions

• Thursday 20 February 2025 Olympes de Gouges 358 10h45-12h45
• Friday 21 February 2025 Sophie Germain 0014 15h45-17h45
• Calendar

Lecture : slides

• Spark high level APIs: SQL

We may come back to several parts of

• Spark low level APIs: RDD
• Python Data Science Stack
• Dask

Notebooks

We shall spend most of the lectures on

• Jupyter notebook VI : Spark SQL
• html: Spark SQL
  
• Jupyter notebook VII : JSON
• html: JSON

and possibly compare with:

Dask Tutorial

You shall have gone through (on your own)

• Jupyter notebook V : Spark RDD
• html: Spark RDD
  
• 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 ⏎