[
https://issues.apache.org/jira/browse/HAWQ-296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo updated HAWQ-296:
-----------------------------
Affects Version/s: 2.0.0-beta-incubating
> 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: Lei Chang
>
> 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)
