[ https://issues.apache.org/jira/browse/FLINK-18445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-18445: ----------------------------------- Labels: auto-deprioritized-major auto-deprioritized-minor pull-request-available (was: auto-deprioritized-major auto-deprioritized-minor) > Short circuit join condition for lookup join > -------------------------------------------- > > Key: FLINK-18445 > URL: https://issues.apache.org/jira/browse/FLINK-18445 > Project: Flink > Issue Type: Improvement > Components: Table SQL / Runtime > Reporter: Rui Li > Assignee: lincoln lee > Priority: Minor > Labels: auto-deprioritized-major, auto-deprioritized-minor, > pull-request-available > Fix For: 1.19.0 > > > Consider the following query: > {code} > select * > from probe > left join > build for system_time as of probe.ts > on probe.key=build.key and probe.col is not null > {code} > In current implementation, we lookup each probe.key in build to decide > whether a match is found. A possible optimization is to skip the lookup for > rows whose {{col}} is null. -- This message was sent by Atlassian Jira (v8.20.10#820010)