Hi Timo! I'm moving away from SQL to DataStream. On Thu, Feb 11, 2021 at 9:11 AM Timo Walther <twal...@apache.org> wrote:
> 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? > >