[jira] [Created] (HAWQ-708) Consume latest GPORCA features up to version 1.630

["xin zhang (JIRA)" <ji...@apache.org>]

xin zhang created HAWQ-708:
------------------------------

             Summary: Consume latest GPORCA features up to version 1.630
                 Key: HAWQ-708
                 URL: https://issues.apache.org/jira/browse/HAWQ-708
             Project: Apache HAWQ
          Issue Type: Improvement
          Components: Optimizer
            Reporter: xin zhang
            Assignee: Amr El-Helw


There are additional GPORCA features benefiting the HAWQ community, and this ticket is to bump the GPORCA from version 1.627 to 1.630. Here is list of new features in GPORCA:

-- 1.628 and rename EatMalloc to EatTracker

   Better memory tracking.

-- 1.629 to include new GUC for Join Exploration

    New GUC optimizer_join_arity_for_associativity_commutativity is added to
    control Join exploration, hence speed up optimization time [#116333899]

    For example, `set optimizer_join_arity_for_associativity_commutativity=x` will
    hint at the optimizer to stop exploring join associativity and join
    commutativity transformations when an n-ary join operator has more than
    x children during optimization, pruning quite a bit of the search space.

-- 1.630 to fix CTE Predicate pushdown

    This fix will prevent predicate pushdown with volatile function like
    random(), which caused wrong result if predicates were duplicated.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)