[
https://issues.apache.org/jira/browse/HAWQ-296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15074848#comment-15074848
]
ASF GitHub Bot commented on HAWQ-296:
-------------------------------------
GitHub user huor opened a pull request:
https://github.com/apache/incubator-hawq/pull/232
HAWQ-296. TPC-H Query 5 encounters OOM in large HAWQ cluster with None mode
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/huor/incubator-hawq github_huor_oom
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/232.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 #232
----
commit 76a02fa530b8b23c9d24c2501bc18e94128adaeb
Author: Ruilong Huo <[email protected]>
Date: 2015-12-30T09:35:35Z
HAWQ-296. TPC-H Query 5 encounters OOM in large HAWQ cluster with None mode
----
> TPC-H Query 5 encounters OOM in large HAWQ cluster with None mode
> -----------------------------------------------------------------
>
> Key: HAWQ-296
> URL: https://issues.apache.org/jira/browse/HAWQ-296
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Resource Manager
> Affects Versions: 2.0.0-beta-incubating
> Reporter: Ruilong Huo
> Assignee: Ruilong Huo
>
> TPC-H Query 5 encounters OOM in large HAWQ cluster with None mode.
> OOM in EXPLAIN ANALYZE of TPC-H Query 5:
> {noformat}
> explain analyze select
> n_name,
> sum(l_extendedprice * (1 - l_discount)) as revenue
> from
> customer,
> orders,
> lineitem,
> supplier,
> nation,
> region
> where
> c_custkey = o_custkey
> and l_orderkey = o_orderkey
> and l_suppkey = s_suppkey
> and c_nationkey = s_nationkey
> and s_nationkey = n_nationkey
> and n_regionkey = r_regionkey
> and r_name = 'ASIA'
> and o_orderdate >= date '1997-01-01'
> and o_orderdate < date '1997-01-01' + interval '1 year'
> group by
> n_name
> order by
> revenue desc;
> 532767 [2015-12-25 23:52:39]
> NOTICE: Canceling query because of high VMEM usage. Used: 11060MB, available
> 1228MB, red zone: 11056MB (runaway_cleaner.c:152) (seg969 test45.ic:40000
> pid=738560)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
