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

Posted to issues@hive.apache.org by "liguangyu (Jira)" <ji...@apache.org> on 2021/04/10 15:09:00 UTC

[jira] [Commented] (HIVE-58) [hive] join condition does not allow a simple filter

    [ https://issues.apache.org/jira/browse/HIVE-58?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17318524#comment-17318524 ] 

liguangyu commented on HIVE-58:
-------------------------------

select .... from A join B ON A.a = B.b where A.x=10

> [hive] join condition does not allow a simple filter
> ----------------------------------------------------
>
>                 Key: HIVE-58
>                 URL: https://issues.apache.org/jira/browse/HIVE-58
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>            Priority: Major
>             Fix For: 0.3.0
>
>
> In the join condition, a simple filter condition cannot be specified.
> For example,
>   select .... from A join B ON (A.a = B.b and A.x = 10);
> is not supported.  This can be very useful specially in case of outer joins.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)