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 > link://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html#joins > > <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 <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>
