[jira] [Created] (HAWQ-296) TPC-H Query 5 encounters OOM in large HAWQ cluster with None mode

["Ruilong Huo (JIRA)" <ji...@apache.org>]

Ruilong Huo created HAWQ-296:
--------------------------------

             Summary: 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
            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)