[ https://issues.apache.org/jira/browse/BEAM-6112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16766713#comment-16766713 ]
Rui Wang commented on BEAM-6112: -------------------------------- There is a related stackoverflow question: https://stackoverflow.com/questions/54651784/rexcall-cannot-be-cast-to-rexinputref-exception-in-apache-beam-sql > 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)