Del via


withWatermark

Defines an event time watermark for this DataFrame. A watermark tracks a point in time before which we assume no more late data is going to arrive.

Syntax

withWatermark(eventTime: str, delayThreshold: str)

Parameters

Parameter Type Description
eventTime str the name of the column that contains the event time of the row.
delayThreshold str the minimum delay to wait to data to arrive late, relative to the latest record that has been processed in the form of an interval (e.g. "1 minute" or "5 hours").

Returns

DataFrame: Watermarked DataFrame.

Notes

This is a feature only for Structured Streaming.

Spark will use this watermark for several purposes:

  • To know when a given time window aggregation can be finalized and thus can be emitted when using output modes that do not allow updates.
  • To minimize the amount of state that we need to keep for on-going aggregations.

The current watermark is computed by looking at the MAX(eventTime) seen across all of the partitions in the query minus a user specified delayThreshold. Due to the cost of coordinating this value across partitions, the actual watermark used is only guaranteed to be at least delayThreshold behind the actual event time.

Examples

from pyspark.sql import Row
from pyspark.sql.functions import timestamp_seconds
df = spark.readStream.format("rate").load().selectExpr(
    "value % 5 AS value", "timestamp")
df.select("value", df.timestamp.alias("time")).withWatermark("time", '10 minutes')
# DataFrame[value: bigint, time: timestamp]