B between A and A + INTERVAL '7' DAY 个人感觉 A between B - INTERVAL '7' DAY and B 更容易理解一些
参见: https://nightlies.apache.org/flink/flink-docs-release-1.14/docs/dev/table/sql/queries/joins/#interval-joins 在 2021/12/31 17:57, mayifan 写道:
Hi,各位大佬! Flink SQL双流JOIN,先有的A流后有的B流,现在需要对A流状态保留7天,然后用B流去关联A流 正确的写法是 B between A and A + INTERVAL '7' DAY 还是 B between A - INTERVAL '7' DAY and A 期待大佬们的答复~! 非常感谢~!