GitHub user xinzweb opened a pull request:
https://github.com/apache/incubator-hawq/pull/978
HAWQ-1122. Bump GPORCA to v1.674 and GPOS to v1.145
After the porting, HAWQ can build with `GPORCA v1.674`. However, there are
few failures spotted:
**make installcheck-good**:
```
test hcatalog_lookup ... FAILED (3.63 sec)
=======================
1 of 15 tests failed.
=======================
```
**src/test/feature/feature-test**:
```
TestExternalTable.TestExternalTableAll
... and still running ...
```
This is go beyond context of GPORCA, and we need HAWQ team to step-in, and
help fixing the failed tests. @paul-guo-
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/xinzweb/incubator-hawq
133081355_hawq_bump_version_674
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/978.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 #978
----
commit 08756ae86197c8fd33a6ad48cde6666ee71e56bc
Author: Karthikeyan Jambu Rajaraman <[email protected]>
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 <[email protected]>
commit 49a8b662c86206e3493736c720c48be57e23a46b
Author: Karthikeyan Jambu Rajaraman <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
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 <[email protected]>
Date: 2016-10-26T23:09:01Z
HAWQ-1122. Bump GPORCA to v1.674 and GPOS to v1.145
Signed-off-by: Omer Arap <[email protected]>
----
---
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 [email protected] or file a JIRA ticket
with INFRA.
---
