Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.4.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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

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

                Dates

                • Created:
                  Updated: