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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15275884#comment-15275884 ] 

ASF GitHub Bot commented on HAWQ-708:
-------------------------------------

Github user liming01 commented on the pull request:

    https://github.com/apache/incubator-hawq/pull/631#issuecomment-217765803
  
    Hi @xinzweb,  I have merged it, please close this PR. Thanks.


> 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)