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

user should not specify mapjoin to perform sort-merge bucketed join

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • None
    • Reviewed

    Description

      Currently, in order to perform a sort merge bucketed join, the user needs
      to set hive.optimize.bucketmapjoin.sortedmerge to true, and also specify the
      mapjoin hint.

      The user should not specify any hints.

      Attachments

        1. auto_sortmerge_join_1_modified.q
          2 kB
          Vikram Dixit K
        2. hive.3403.1.patch
          225 kB
          Namit Jain
        3. hive.3403.10.patch
          412 kB
          Namit Jain
        4. hive.3403.11.patch
          414 kB
          Namit Jain
        5. hive.3403.12.patch
          414 kB
          Namit Jain
        6. hive.3403.13.patch
          308 kB
          Namit Jain
        7. hive.3403.14.patch
          311 kB
          Namit Jain
        8. hive.3403.15.patch
          311 kB
          Namit Jain
        9. hive.3403.16.patch
          407 kB
          Namit Jain
        10. hive.3403.17.patch
          407 kB
          Namit Jain
        11. hive.3403.18.patch
          407 kB
          Namit Jain
        12. hive.3403.19.patch
          381 kB
          Namit Jain
        13. hive.3403.2.patch
          231 kB
          Namit Jain
        14. hive.3403.21.patch
          406 kB
          Namit Jain
        15. hive.3403.22.patch
          488 kB
          Namit Jain
        16. hive.3403.23.patch
          488 kB
          Namit Jain
        17. hive.3403.24.patch
          488 kB
          Namit Jain
        18. hive.3403.25.patch
          490 kB
          Namit Jain
        19. hive.3403.26.patch
          522 kB
          Namit Jain
        20. hive.3403.27.patch
          554 kB
          Namit Jain
        21. hive.3403.28.patch
          554 kB
          Namit Jain
        22. hive.3403.29.patch
          552 kB
          Namit Jain
        23. hive.3403.3.patch
          420 kB
          Namit Jain
        24. hive.3403.30.patch
          552 kB
          Namit Jain
        25. hive.3403.4.patch
          420 kB
          Namit Jain
        26. hive.3403.5.patch
          432 kB
          Namit Jain
        27. hive.3403.6.patch
          473 kB
          Namit Jain
        28. hive.3403.7.patch
          491 kB
          Namit Jain
        29. hive.3403.8.patch
          403 kB
          Namit Jain
        30. hive.3403.9.patch
          404 kB
          Namit Jain

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3283 bucket information should be used from the partition instead of the table

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-3633 sort-merge join does not work with sub-queries

          • Major - Major loss of function.
          • Closed
          is a clone of

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3402 user should not specify mapjoin to perform bucketed join

          • Major - Major loss of function.
          • Resolved
          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3892 auto sort merge join does not work for sub-queries

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3598 physical optimizer changes for auto sort-merge join

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3891 physical optimizer changes for auto sort-merge join

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3980 Cleanup after HIVE-3403

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-3784 de-emphasize mapjoin hint

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-3784 de-emphasize mapjoin hint

          • Major - Major loss of function.
          • Closed

          Activity

            People

              namit Namit Jain
              namit Namit Jain
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: