hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5464) allow OR conditions in table join
Date Sun, 06 Oct 2013 15:53:42 GMT

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

Edward Capriolo commented on HIVE-5464:
---------------------------------------

Hive only supports equi-joins like this. You can still accomplish this query using a cart-product.
Map Reduce can not easily make this query efficient, are you planning to work on this? We
have to think carefully if we want this. There is a big danger in adding things to hive that
can not be done efficiently in map/reduce.

> allow OR conditions in table join
> ---------------------------------
>
>                 Key: HIVE-5464
>                 URL: https://issues.apache.org/jira/browse/HIVE-5464
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 0.11.0
>            Reporter: N Campbell
>
> select tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 tjoin1 inner join tjoin2 tjoin2
on ( tjoin1.c1 = 10 or tjoin1.c1=20 )
> Query returned non-zero code: 10019, cause: FAILED: SemanticException [Error 10019]:
Line 1:96 OR not supported in JOIN currently '20'



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message