[HAWQ-80] Support dynamic relation distribution type in gpopt

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Optimizer
• Assignee: Amr El-Helw
• Reporter: Entong Shen
• Created: 23/Oct/15 23:28
• Updated: 24/Jan/16 01:35
• Resolved: 03/Nov/15 19:41

Description

If there are 3 hash distributed tables in a query, each has a different buckets number, say 8, 24 and 64, the resource negotiator will allocate max(8,24,64)=64 vSegs. In this case, the tables with buckets number 8 and 24 will need to be regarded as random distributed table during planning.