[HIVE-556] let hive support theta join

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.4.0
• Assignee: Brock Noland
• Reporter: Min Zhou
• Created: 11/Jun/09 04:20
• Updated: 25/Oct/14 03:04

Description

Right now , hive only support equal joins . Sometimes it's not enough, we must consider implementing theta joins like

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';

any condition expression following 'ON' is appropriate.

Issue Links

• links to: Design Doc