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 2015/11/06 11:24:27 UTC
[jira] [Commented] (HAWQ-135) Explain generate serial will cause
coredump in optimizer off
[ https://issues.apache.org/jira/browse/HAWQ-135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14993462#comment-14993462 ]
ASF GitHub Bot commented on HAWQ-135:
-------------------------------------
GitHub user liming01 opened a pull request:
https://github.com/apache/incubator-hawq/pull/82
HAWQ-135. Fixed coredump when explain generate_serial in optimizer off
Need to set query as DISPATCH_SEQUENTIAL when legacy query optimizer doesn't set it as DISPATCH_PARALLEL.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/liming01/incubator-hawq mli/explain_crash_legacy_opt
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/82.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 #82
----
commit 0306f0cf2ca6e24b6d7b7bc439f417647fb8c86f
Author: Ming LI <ml...@pivotal.io>
Date: 2015-11-06T10:15:29Z
HAWQ-135. Fixed coredump when explain generate_serial in optimizer off
----
> Explain generate serial will cause coredump in optimizer off
> ------------------------------------------------------------
>
> Key: HAWQ-135
> URL: https://issues.apache.org/jira/browse/HAWQ-135
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Optimizer
> Reporter: Ming LI
> Assignee: Ming LI
>
> SET optimizer=off;
> EXPLAIN ANALYZE
> SELECT COUNT(i1) FROM generate_series(0,499) i1, generate_series(100,199) i2
> GROUP BY i1,i2;
> all other simplest query will crash when executed with 'optimizer=off'
> explain select generate_series(0,499);
> explain select 1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)