You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by paul-guo- <gi...@git.apache.org> on 2016/10/28 03:49:36 UTC
[GitHub] incubator-hawq pull request #983: Orca 978
GitHub user paul-guo- opened a pull request:
https://github.com/apache/incubator-hawq/pull/983
Orca 978
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/paul-guo-/incubator-hawq orca-978
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/983.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 #983
----
commit 08756ae86197c8fd33a6ad48cde6666ee71e56bc
Author: Karthikeyan Jambu Rajaraman <ka...@gmail.com>
Date: 2016-04-26T15:21:50Z
HAWQ-1122. Fix ORCA - gpdb exception handling. This closes #793
Any GPDB exception happens in while ORCA generating plan will abort
query.
This is cherry-picked from greenplum-db/gpdb@045d437cc1240b0d804ce4a37b5b165ec216afd7
Signed-off-by: Foyzur Rahman <fr...@gmail.com>
commit 49a8b662c86206e3493736c720c48be57e23a46b
Author: Karthikeyan Jambu Rajaraman <ka...@gmail.com>
Date: 2016-07-06T20:53:08Z
HAWQ-1122. Print exception message as warning and abort plan generation.(#920)
This is cherry-picked from greenplum-db/gpdb@36b504e65ef2fe68b13c773df9d80a90ddcc9b55
commit 11739464b0ba0f0f4d23565f1f61c02d3884c1fd
Author: Karthikeyan Jambu Rajaraman <ka...@gmail.com>
Date: 2016-07-15T17:55:24Z
HAWQ-1122. Remove unnecessary assert that cause orca to fallback planner for insert query
This is cherry-picked from greenplum-db/gpdb@1ee7d3d62ef0fcfe329ba1a7317ab938fb47ff7a
commit 7c67ce89a9252a3858de57be1921874964f5cc82
Author: Haisheng Yuan <hy...@pivotal.io>
Date: 2016-07-28T00:03:32Z
HAWQ-1122. Add ORCA optimizer GUC optimizer_parallel_union for parallel append (#977)
This GUC is disabled by default.
Currently, when users run an `UNION ALL` query, such as
```sql
SELECT a FROM foo UNION ALL SELECT b FROM bar
```,
GPDB will parallelize the execution across all the segments, but the
table scans on `foo` and `bar` are not executed parallel. With this GUC
enabled, we add redistribution motion node under APPEND(UNION) operator,
which makes all the children of APPEND(UNION) operator execute in
parallel in every segment.
This is cherry-picked from greenplum-db/gpdb@86e49e51d39ed0d252cbf6a79c2fc62e36a4e307
commit 6408c7989176e974e46808f200690ace432f63e3
Author: Marc Spehlmann <ma...@gmail.com>
Date: 2016-08-01T15:53:58Z
HAWQ-1122. Adds a GUC to enable array constraint derivation.
A new feature of ORCA is to more efficiently handle array constraints.
It includes a new preprocessing stage, and a new way of internally
representing array constraints. This feature can be enabled by use of
this GUC.
This is cherry-picked from greenplum-db/gpdb@c85f858ec725ec14a6e7870749f3a03fb2597310
commit 5d38f683057b050e2d07b5533a2cb8c379f81f91
Author: Marc Spehlmann <ma...@gmail.com>
Date: 2016-08-01T15:53:58Z
HAWQ-1122. Adds a GUC to enable array constraint derivation.
This fixes the naming in c85f858ec725ec14a6e7870749f3a03fb2597310
A new feature of ORCA is to more efficiently handle array constraints.
It includes a new preprocessing stage, and a new way of internally
representing array constraints. This feature can be enabled by use of
this GUC.
This is cherry-picked from greenplum-db/gpdb@8ba520bd9f4f82ced764075ac1eb35c121dadfed
commit 03b60e988f56ba8f6228cf3a7559978667b43e57
Author: Haisheng Yuan <hy...@pivotal.io>
Date: 2016-08-09T05:23:07Z
HAWQ-1122. Fix bug in index dxl translators that can't translatte ScalarArrayOpExpr [#126158185]
Orca couldn't pickup plan that uses index scan for the following cases:
select * from btree_tbl where a in (1,2);
--> Orca generated table scan instead of index scan
select * from bitmap_tbl where a in (1,2);
--> Orca generated table scan instead of bitmap scan
Orca failed to consider the case that uses ArrayComp
when trying to pick up index.
The issue has been fixed in this patch.
Closes #993
This is cherry-picked from greenplum-db/gpdb@cfafef0005191a63973e53076c5e08b0face68a0
commit ddb93ff4527f61ed4134fa4b3c3136d16d2f87bd
Author: Haisheng Yuan <hy...@pivotal.io>
Date: 2016-08-12T18:57:53Z
HAWQ-1122. Guard against ScalarArrayOpExpr qual under Index Scan [#128092771]
Also updated gp_optimizer expected output and ignore line number
difference for functions.c
This is cherry-picked from greenplum-db/gpdb@684b429457f820f13db730ff46601b299582cb3c
commit 94d53f6d5168ad4961e95c834b4bc0415382aa12
Author: Karthikeyan Jambu Rajaraman <ka...@gmail.com>
Date: 2016-08-18T22:41:18Z
HAWQ-1122. Fix translator to show missing message from exception
This is cherry-picked from greenplum-db/gpdb@7f10e308c957505b2f9d896e1983ac3c13b5ed94
commit 7e59204671c2f4a4cf3aeac95471419d5b252ab1
Author: Haisheng Yuan <hy...@pivotal.io>
Date: 2016-08-14T17:39:32Z
HAWQ-1122. Remove unused file load.sql
Through the file content we know it uses personal absolute path, which
can't be used by others. DisableXform/EnableXform are already built-in
functions if GPDB is built with Orca. So we can safely delete this file.
This is cherry-picked from greenplum-db/gpdb@1033c5362f19f0121eddf314a49b319f3582aa9e
commit 926628bd987a97ad4ab112d6dbaf9b5b7d2d25f0
Author: Karthikeyan Jambu Rajaraman <ka...@gmail.com>
Date: 2016-08-18T22:41:59Z
HAWQ-1122. Convert elog::ERROR to elog::WARNING in translator and throw exception to stop execution
This is cherry-picked from greenplum-db/gpdb@386861225f3a027f45de8f21d73f2d2ec40129ec
commit 5b50a8ac195361fc101a46fb3fad74f5876243df
Author: Haisheng Yuan <hy...@pivotal.io>
Date: 2016-08-19T21:20:27Z
HAWQ-1122. Update Orca dxl translator error message
This is cherry-picked from greenplum-db/gpdb@29a2bed2e98be02210aa960ba32ed6fbe5021faf
commit c4d2fff3b7ddf2132d28223c1d8d9163a0fd5cb5
Author: Venkatesh (Venky) Raghavan <vr...@pivotal.io>
Date: 2016-09-29T22:41:08Z
HAWQ-1122. Hint to disable NAryJoinDP when join has large number of children [#121181555]
This is cherry-picked from greenplum-db/gpdb@30a9ed3f8758a8ef192fc66c285a4e2b61228bbb
commit 4b68d3fbb98037ed3ae5129e6ed4044cdeb07e94
Author: Xin Zhang <xz...@pivotal.io>
Date: 2016-10-26T23:09:01Z
HAWQ-1122. Bump GPORCA to v1.674 and GPOS to v1.145
Signed-off-by: Omer Arap <oa...@pivotal.io>
commit ecc8c042467aac30d5a9cc2753ed6b6b7b4c4efc
Author: Paul Guo <pa...@gmail.com>
Date: 2016-10-27T05:59:00Z
HAWQ-1122. Fix feature test case failures which are introduced by GPORCA upgradation.
----
---
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 #983: Orca 978
Posted by paul-guo- <gi...@git.apache.org>.
Github user paul-guo- closed the pull request at:
https://github.com/apache/incubator-hawq/pull/983
---
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 issue #983: Orca 978
Posted by radarwave <gi...@git.apache.org>.
Github user radarwave commented on the issue:
https://github.com/apache/incubator-hawq/pull/983
+1
---
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.
---