[
https://issues.apache.org/jira/browse/HIVE-556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718699#action_12718699
]
Min Zhou commented on HIVE-556:
-------------------------------
@Ashish
I agree with you, map-side joins is okay. however, it doesnot support theta
joins right now. we used to load aux tables into the memory of each map node,
scan major tables and do our joins.
> let hive support theta join
> ---------------------------
>
> Key: HIVE-556
> URL: https://issues.apache.org/jira/browse/HIVE-556
> Project: Hadoop Hive
> Issue Type: New Feature
> Affects Versions: 0.4.0
> Reporter: Min Zhou
> Fix For: 0.4.0
>
>
> Right now , hive only support equal joins . Sometimes it's not enough, we
> must consider implementing theta joins like
> {code:sql}
> SELECT
> a.subid, a.id, t.url
> FROM
> tbl t JOIN aux_tbl a ON t.url rlike a.url_pattern
> WHERE
> t.dt='20090609'
> AND a.dt='20090609';
> {code}
> any condition expression following 'ON' is appropriate.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
