Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major 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.

        Issue Links

          Activity

          Min Zhou created issue -
          Min Zhou made changes -
          Field Original Value New Value
          Description 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.

          Right now , hive only support equal joins . Sometimes 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.

          Johan Oskarsson made changes -
          Fix Version/s 0.5.0 [ 12314156 ]
          Fix Version/s 0.4.0 [ 12313714 ]
          Namit Jain made changes -
          Fix Version/s 0.5.0 [ 12314156 ]
          Brock Noland made changes -
          Assignee Brock Noland [ brocknoland ]
          Brock Noland made changes -
          Remote Link This issue links to "Design Doc (Web Link)" [ 12403 ]

            People

            • Assignee:
              Brock Noland
              Reporter:
              Min Zhou
            • Votes:
              7 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

              • Created:
                Updated:

                Development