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

Posted to issues@beam.apache.org by "Rui Wang (JIRA)" <ji...@apache.org> on 2019/04/16 21:55:00 UTC

[jira] [Assigned] (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 ]

Rui Wang reassigned BEAM-6112:
------------------------------

    Assignee: Rui Wang

> 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
>            Assignee: Rui Wang
>            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)