Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5381

Add query option to control join strategy when tables have no stats

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Impala 2.9.0
    • Component/s: Frontend
    • Labels:
      None

      Description

      In IMPALA-5120 the join strategy was changed from bcast to shuffle when tables have no stats. Adding a query option to specify the behavior lowers the risk that users may have come to rely on this behavior. This would allow them to revert back to the previous behavior.

      Query option proposal:

      default_join_distribution_mode = [ broadcast | shuffle ] 
      

      Ideally, the default would be shuffle, but in the spirit of preserving existing behavior it will stay broadcast. We should re-evaluate this choice in a compatibility-breaking release.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex.behm Alexander Behm
                Reporter:
                grahn Greg Rahn
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: