pyspark.sql.functions.months

pyspark.sql.functions.months(col: ColumnOrName) → pyspark.sql.column.Column

Partition transform function: A transform for timestamps and dates to partition data into months.

New in version 3.1.0.

Changed in version 3.4.0: Supports Spark Connect.

Parameters

colColumn or str

target date or timestamp column to work on.

Returns

Column

data partitioned by months.

Notes

This function can be used only in combination with partitionedBy() method of the DataFrameWriterV2.

Examples

>>> df.writeTo("catalog.db.table").partitionedBy(
...     months("ts")
... ).createOrReplace()  

pyspark.sql.functions.years pyspark.sql.functions.days