SQL could support equijoins on complex expressions, not just column refs
Open
dsl
new feature
P3
sql
- Dominant language
- Java
- Stars
- 8.7k
- Forks
- 4.7k
- Avg merge
- 1d 20h
- Merged PRs (30d)
- 196
Description
Currently a join such as `CAST(A.x AS BIGINT) = B.y` will fail, along with other similar simple expressions. We only support joining directly on immediate column references. It can be worked around by inserting a WITH clause for the intermediate value.
Imported from Jira [BEAM-6112](https://issues.apache.org/jira/browse/BEAM-6112). Original Jira may contain additional context.
Reported by: kenn.
Contributor guide
Assessment
This issue has not been assessed yet.