You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by xinzweb <gi...@git.apache.org> on 2016/04/26 23:54:48 UTC

[GitHub] incubator-hawq pull request: HAWQ-708. Bump GPORCA to 1.630 [#1176...

GitHub user xinzweb opened a pull request:

    https://github.com/apache/incubator-hawq/pull/631

    HAWQ-708. Bump GPORCA to 1.630 [#117643411]

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

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/xinzweb/incubator-hawq bump_gpopt_to_630

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/631.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #631
    
----
commit 07bd6bd6284dbd2b1cf310c1b28a023b65c4a93d
Author: Shreedhar Hardikar and Xin Zhang <sh...@pivotal.io>
Date:   2016-04-26T19:24:56Z

    HAWQ-708. Bump GPORCA to 1.630 [#117643411]
    
    -- 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.

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq pull request: HAWQ-708. Bump GPORCA to 1.630 [#1176...

Posted by liming01 <gi...@git.apache.org>.
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.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq pull request: HAWQ-708. Bump GPORCA to 1.630 [#1176...

Posted by xinzweb <gi...@git.apache.org>.
Github user xinzweb closed the pull request at:

    https://github.com/apache/incubator-hawq/pull/631


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

[GitHub] incubator-hawq pull request: HAWQ-708. Bump GPORCA to 1.630 [#1176...

Posted by xinzweb <gi...@git.apache.org>.
Github user xinzweb commented on the pull request:

    https://github.com/apache/incubator-hawq/pull/631#issuecomment-218215908
  
    Merged: https://github.com/apache/incubator-hawq/commit/1f7d98e64640cc075e4249d9eaf3434bd2f935fc


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---