This message was deleted.
# troubleshootings
Slackbot
06/07/2023, 7:00 AMThis message was deleted.
m
Martijn Visser
06/07/2023, 7:09 AMYour join is a regular join, which means that it's required to keep all sides of the join input in Flink state forever. This is documented at https://nightlies.apache.org/flink/flink-docs-release-1.17/docs/dev/table/sql/queries/joins/
You could consider setting a TTL, but that can have implications on the correctness of the query result
Martijn Visser
06/07/2023, 7:14 AMI'm not sure it's an interval join given the amount of joins that you're doing
Martijn Visser
06/07/2023, 7:15 AMAh, you actually also use the old HOP function
Martijn Visser
06/07/2023, 7:15 AMThe statement is so long that I actually didn't see that at first