You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/04/26 23:55:13 UTC
[jira] [Commented] (HAWQ-708) Consume latest GPORCA features up to
version 1.630
[ https://issues.apache.org/jira/browse/HAWQ-708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15259007#comment-15259007 ]
ASF GitHub Bot commented on HAWQ-708:
-------------------------------------
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.
----
> 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)