[ https://issues.apache.org/jira/browse/BEAM-6112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kenneth Knowles updated BEAM-6112: ---------------------------------- 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. > SQL could support equijoins on complex expressions, not just column refs > ------------------------------------------------------------------------ > > Key: BEAM-6112 > URL: https://issues.apache.org/jira/browse/BEAM-6112 > Project: Beam > Issue Type: New Feature > Components: dsl-sql > Reporter: Kenneth Knowles > Priority: Major > > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)