pyflink.table.expressions.temporal_overlaps

temporal_overlaps(left_time_point, left_temporal, right_time_point, right_temporal) → pyflink.table.expression.Expression

Determines whether two anchored time intervals overlap. Time point and temporal are transformed into a range defined by two time points (start, end). The function evaluates left_end >= right_start && right_end >= left_start.

e.g.

temporal_overlaps(

lit(“2:55:00”).to_time, lit(1).hours, lit(“3:30:00”).to_time, lit(2).hours) leads to true.

Parameters

• left_time_point – The left time point

• left_temporal – The time interval from the left time point

• right_time_point – The right time point

• right_temporal – The time interval from the right time point

Returns

An expression which indicates whether two anchored time intervals overlap.

New in version 1.12.0.