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

map-side joins are not supported

        Details

        • Type: New Feature
        • Status: Closed
        • Priority: 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. Text File
            195.patch1.txt
            267 kB
            Namit Jain
          2. Text File
            195.patch2.txt
            498 kB
            Namit Jain
          3. Text File
            195.patch3.txt
            529 kB
            Namit Jain
          4. Text File
            hive.195.4.patch
            928 kB
            Namit Jain
          5. Text File
            hive.195.5.patch
            964 kB
            Namit Jain
          6. Text File
            hive.195.6.patch
            964 kB
            Namit Jain
          7. Text File
            hive.195.7.patch
            961 kB
            Namit Jain
          8. Text File
            hive.195.8.patch
            961 kB
            Namit Jain
          9. Text File
            hive.195.9.patch
            963 kB
            Namit Jain

            Issue Links

            is related to

            New Feature - A new feature of the product, which has yet to be developed. HIVE-917 Bucketed Map Join

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              namit Namit Jain added a comment -

              added more tests

              Show
              namit Namit Jain added a comment - added more tests
              Hide
              Permalink
              jsensarma 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
              jsensarma 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
              Hide
              Permalink
              namit 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

              Show
              namit 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
              Permalink
              namit Namit Jain added a comment -

              merged conflicts with 467

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

              more conflicts

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

              +1

              Running test now. Will checkin once it is done.

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

              Tests are failing on my run.

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

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

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

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

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

              Committed. Thanks Namit!

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

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Development