You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Zhong Yanghong (Jira)" <ji...@apache.org> on 2020/05/12 06:03:00 UTC

[jira] [Created] (KYLIN-4492) Bad query leads to full gc

Zhong Yanghong created KYLIN-4492:
-------------------------------------

             Summary: Bad query leads to full gc
                 Key: KYLIN-4492
                 URL: https://issues.apache.org/jira/browse/KYLIN-4492
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
            Reporter: Zhong Yanghong


The following sql goes into dead loop of calcite sql parser leading to OOM

{code}

select LSTG_FORMAT_NAME,
 cast(sum(t.sid_cnt) as bigint) as sid_cnts
from
 (select LSTG_FORMAT_NAME,
 count(distinct SELLER_ID) as sid_cnt
 from TEST_KYLIN_FACT
 group by LSTG_FORMAT_NAME) t
group by LSTG_FORMAT_NAME
order by sid_cnts

{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)