Hive
  1. Hive
  2. HIVE-195

map-side joins are not supported

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      HIVE-195. Map-side join. (Namit Jain via zshao)

      Description

      map-side joins are not supported.

      If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
      to start with, the user should be given an option to specify that he needs a map-side join.

      1. hive.195.9.patch
        963 kB
        Namit Jain
      2. hive.195.8.patch
        961 kB
        Namit Jain
      3. hive.195.7.patch
        961 kB
        Namit Jain
      4. hive.195.6.patch
        964 kB
        Namit Jain
      5. hive.195.5.patch
        964 kB
        Namit Jain
      6. hive.195.4.patch
        928 kB
        Namit Jain
      7. 195.patch3.txt
        529 kB
        Namit Jain
      8. 195.patch2.txt
        498 kB
        Namit Jain
      9. 195.patch1.txt
        267 kB
        Namit Jain

        Issue Links

          Activity

          Hide
          Namit Jain added a comment -

          added more tests

          Show
          Namit Jain added a comment - added more tests
          Hide
          Joydeep Sen Sarma added a comment -

          here's the ticket for the jdbm enhancement that might help:

          https://sourceforge.net/tracker/?func=detail&atid=354155&aid=2475914&group_id=4155

          Show
          Joydeep Sen Sarma added a comment - here's the ticket for the jdbm enhancement that might help: https://sourceforge.net/tracker/?func=detail&atid=354155&aid=2475914&group_id=4155
          Show
          Namit Jain added a comment - Some cleanups can be performed in follow-ups. Filed new JIRAS: https://issues.apache.org/jira/browse/HIVE-528 https://issues.apache.org/jira/browse/HIVE-529 https://issues.apache.org/jira/browse/HIVE-530 https://issues.apache.org/jira/browse/HIVE-531
          Hide
          Namit Jain added a comment -

          merged conflicts with 467

          Show
          Namit Jain added a comment - merged conflicts with 467
          Hide
          Namit Jain added a comment -

          more conflicts

          Show
          Namit Jain added a comment - more conflicts
          Hide
          Ashish Thusoo added a comment -

          +1

          Running test now. Will checkin once it is done.

          Show
          Ashish Thusoo added a comment - +1 Running test now. Will checkin once it is done.
          Hide
          Ashish Thusoo added a comment -

          Tests are failing on my run.

          Show
          Ashish Thusoo added a comment - Tests are failing on my run.
          Hide
          Namit Jain added a comment -

          The output of join27.q was non-deterministic - fixing that

          Show
          Namit Jain added a comment - The output of join27.q was non-deterministic - fixing that
          Hide
          Namit Jain added a comment -

          missed the testoperators - the test needs to change - missed that since it does not show up failures

          Show
          Namit Jain added a comment - missed the testoperators - the test needs to change - missed that since it does not show up failures
          Hide
          Zheng Shao added a comment -

          Committed. Thanks Namit!

          Show
          Zheng Shao added a comment - Committed. Thanks Namit!

            People

            • Assignee:
              Namit Jain
              Reporter:
              Namit Jain
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development