hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Min Zhou (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-556) let hive support theta join
Date Thu, 11 Jun 2009 04:21:07 GMT
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.


Mime
View raw message