Hey All- I'm trying to do an interval join in the ...
# troubleshooting
c
Hey All- I'm trying to do an interval join in the pyflink Table API where the end point of the interval is dependent on a specific column value. Something akin to this:
Copy code
res_table = input_table.join(event_table) \
                       .where((col("rowtime2") >= col("rowtime1") - lit(750).millis) & \
                              (col("rowtime2") <= col("rowtime1") + lit(col("interval_millis")).millis))
Is this possible? If so, what would be the syntax?
Solved. Had to cast to an interval data type