Skip to main content
PYSPARK โ€ข LESSON 164

Writing Partitioned Parquet Directories

How do we write Parquet data partitioned into hierarchical year and month subdirectories on disk?

Expertโฑ 2 Minutesโญ 900 XP
๐Ÿค” THE QUESTION

How do we write Parquet data partitioned into hierarchical year and month subdirectories on disk?

๐Ÿ’ก WHAT IS IT?

partitionBy('year', 'month') writes data into directory paths like year=2026/month=08/ to enable partition pruning.

๐ŸŽฏ WHAT IS IT USED FOR?

Enabling downstream query engines to skip entire directories when querying specific time ranges.

๐Ÿ’ป EXAMPLE
df.write \
  .mode("overwrite") \
  .partitionBy("year", "month") \
  .parquet("output/partitioned_sales")

๐ŸŽฏ Mission Objectives

Practice typing production-grade PySpark code for Writing Partitioned Parquet Directories.

  • โœ“ Apply partitionBy on write
  • โœ“ Create year/month directory hierarchy
  • โœ“ Enable partition pruning for downstream engines