Flink sql interval join problem

[ゞ野蠻遊戲χ]

Hi all

       I only saw inner interval join on the official website, I don't see outer interval join on the offical website, Is there an example of an OUTER INTERVAL JOIN?

       official website link://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html#joins.

       

Thanks,

Jiazhi

[Leonard Xu]

Hi,

       I only saw inner interval join on the official website, I don't see outer interval join on the offical website, Is there an example of an OUTER INTERVAL JOIN?

       official website <a href="link://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html#joins" class="">link://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html#joins 

The document only shows one example for every kind join because of the space constraints.

You can see all interval join examples from the test code[1], LEFT OUTER, RIGHT OUTER, FULL OUTER and so on.

Best,

Leonard

[1] https://github.com/apache/flink/blob/master/flink-table/flink-table-planner-blink/src/test/scala/org/apache/flink/table/planner/runtime/stream/sql/IntervalJoinITCase.scala