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

SMB joins fail based on bigtable selection policy.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.12.0
    • Component/s: Query Processor
    • Labels:
      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.2.patch
          14 kB
          Vikram Dixit K
        2. HIVE-4611.3.patch
          22 kB
          Vikram Dixit K
        3. HIVE-4611.4.patch
          35 kB
          Vikram Dixit K
        4. HIVE-4611.5.patch.txt
          38 kB
          Vikram Dixit K
        5. HIVE-4611.6.patch.txt
          38 kB
          Vikram Dixit K
        6. HIVE-4611.patch
          21 kB
          Vikram Dixit K

          Activity

            People

            • Assignee:
              vikram.dixit Vikram Dixit K
              Reporter:
              vikram.dixit Vikram Dixit K
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: