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 . Somethings 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.