Hi Dan,
the order of all joins depends on the order in the SQL query by default.
You can also check the following example (not interval joins though) and
swap e.g. b and c:
env.createTemporaryView("a", env.fromValues(1, 2, 3));
env.createTemporaryView("b", env.fromValues(4, 5, 6));
env.createTemporaryView("c", env.fromValues(7, 8, 9));
System.out.println(env.sqlQuery("SELECT * FROM c, b, a").explain());
So you can reorder the tables in the query if that improves performance.
For interval joins, we currently don't provide additional algorithms or
options.
Regards,
Timo
On 11.02.21 05:04, Dan Hill wrote:
Hi! I was curious if there are docs on how to optimize Flink joins. I
looked around and on the Flink docs and didn't see much. I see a little
on the Configuration page.
E.g. one of my jobs has an interval join. Does left vs right matter for
interval join?
