You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Zhong Yanghong (Jira)" <ji...@apache.org> on 2020/05/14 04:08:00 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-4492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zhong Yanghong reassigned KYLIN-4492:
-------------------------------------

    Assignee: Zhong Yanghong

> 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
>            Assignee: Zhong Yanghong
>            Priority: Major
>
> The following sql goes into dead loop of *RuleQueue.popMatch()* in *VolcanoPlanner.findBestExp()* leading to OOM
> {code:java}
> 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)