You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Beam JIRA Bot (Jira)" <ji...@apache.org> on 2020/07/01 17:24:02 UTC

[jira] [Updated] (BEAM-6112) SQL could support equijoins on complex expressions, not just column refs

     [ https://issues.apache.org/jira/browse/BEAM-6112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Beam JIRA Bot updated BEAM-6112:
--------------------------------
    Labels:   (was: stale-P2)

> 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: P3
>
> 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
(v8.3.4#803005)