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

SMB joins fail based on bigtable selection policy.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.11.0
    • 0.12.0
    • Query Processor
    • None

    Description

      The default setting for hive.auto.convert.sortmerge.join.bigtable.selection.policy will choose the big table as the one with largest average partition size. However, this can result in a query failing because this policy conflicts with the big table candidates chosen for outer joins. This policy should just be a tie breaker and not have the ultimate say in the choice of tables.

      Attachments

        1. HIVE-4611.6.patch.txt
          38 kB
          Vikram Dixit K
        2. HIVE-4611.5.patch.txt
          38 kB
          Vikram Dixit K
        3. HIVE-4611.4.patch
          35 kB
          Vikram Dixit K
        4. HIVE-4611.3.patch
          22 kB
          Vikram Dixit K
        5. HIVE-4611.2.patch
          14 kB
          Vikram Dixit K
        6. HIVE-4611.patch
          21 kB
          Vikram Dixit K

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            vikram.dixit Vikram Dixit K Assign to me
            vikram.dixit Vikram Dixit K
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment