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

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Patch Available Patch Available Open Open
          78d 1h 56m 3 Namit Jain 12/Mar/09 01:25
          Open Open Patch Available Patch Available
          83d 16h 55m 4 Namit Jain 03/Jun/09 19:15
          Patch Available Patch Available Resolved Resolved
          7h 11m 1 Zheng Shao 04/Jun/09 02:26
          Resolved Resolved Closed Closed
          925d 22h 41m 1 Carl Steinbach 17/Dec/11 00:07
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Zheng Shao made changes -
          Link This issue is related to HIVE-917 [ HIVE-917 ]
          Zheng Shao made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Release Note HIVE-195. Map-side join. (Namit Jain via zshao)
          Fix Version/s 0.4.0 [ 12313714 ]
          Resolution Fixed [ 1 ]
          Hide
          Zheng Shao added a comment -

          Committed. Thanks Namit!

          Show
          Zheng Shao added a comment - Committed. Thanks Namit!
          Namit Jain made changes -
          Attachment hive.195.9.patch [ 12409831 ]
          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
          Namit Jain made changes -
          Attachment hive.195.8.patch [ 12409818 ]
          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
          Ashish Thusoo added a comment -

          Tests are failing on my run.

          Show
          Ashish Thusoo added a comment - Tests are failing on my run.
          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.
          Namit Jain made changes -
          Attachment hive.195.7.patch [ 12409814 ]
          Hide
          Namit Jain added a comment -

          more conflicts

          Show
          Namit Jain added a comment - more conflicts
          Namit Jain made changes -
          Attachment hive.195.6.patch [ 12409813 ]
          Hide
          Namit Jain added a comment -

          merged conflicts with 467

          Show
          Namit Jain added a comment - merged conflicts with 467
          Namit Jain made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Attachment hive.195.5.patch [ 12409799 ]
          Namit Jain made changes -
          Attachment hive.195.4.patch [ 12409710 ]
          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
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          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
          Namit Jain made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Hide
          Namit Jain added a comment -

          added more tests

          Show
          Namit Jain added a comment - added more tests
          Namit Jain made changes -
          Attachment 195.patch3.txt [ 12396859 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Namit Jain made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Attachment 195.patch2.txt [ 12396751 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Namit Jain made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Field Original Value New Value
          Attachment 195.patch1.txt [ 12396704 ]
          Namit Jain created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development