Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-556

let hive support theta join

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.4.0
    • None
    • None
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              brocknoland Brock Noland
              coderplay Min Zhou
              Votes:
              9 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

                Created:
                Updated: