[
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)
