[
https://issues.apache.org/jira/browse/KYLIN-4492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17106091#comment-17106091
]
Zhong Yanghong commented on KYLIN-4492:
---------------------------------------
Related PR is [https://github.com/Kyligence/calcite/pull/136]
> 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
> 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)
