You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by vraghavan78 <gi...@git.apache.org> on 2016/01/15 21:03:49 UTC
[GitHub] incubator-hawq pull request: Fallback to planner for command: ALTE...
GitHub user vraghavan78 opened a pull request:
https://github.com/apache/incubator-hawq/pull/273
Fallback to planner for command: ALTER TABLE SET DISTRIBUTED BY
When the user fires the following query:
```
alter table redist_test set with (reorganize=true) distributed randomly;
```
The intention of the user is to force redistribute the tuple so that there is no skew.
Under the hood, GPDB first creates a temp table via CTAS and then replaces the table with the temp table. Given that source table and the temp table are both random, Orca says random satisfies random and therefore no tuple relocation via motions is needed. This changes the expected behavior.
The fix inside Orca is quite extensive, so the immediate stop gap is to fall back to the planner when we execute the CTAS.
#permalink
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/vraghavan78/incubator-hawq altertbl
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/273.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 #273
----
commit 90ab2d40663c06cf87b40ab38c5ffb36c044fdc3
Author: Venkatesh Raghavan <vr...@pivotal.io>
Date: 2016-01-15T20:01:46Z
Fallback to planner for command: ALTER TABLE SET DISTRIBUTED BY
----
---
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: Fallback to planner for command: ALTE...
Posted by xinzweb <gi...@git.apache.org>.
Github user xinzweb commented on the pull request:
https://github.com/apache/incubator-hawq/pull/273#issuecomment-172074021
LGTM
---
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: Fallback to planner for command: ALTE...
Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-hawq/pull/273
---
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: Fallback to planner for command: ALTE...
Posted by hsyuan <gi...@git.apache.org>.
Github user hsyuan commented on the pull request:
https://github.com/apache/incubator-hawq/pull/273#issuecomment-172072266
LGTM.
---
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.
---