[
https://issues.apache.org/jira/browse/KYLIN-4492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-4492:
----------------------------------
Description:
The following sql goes into dead loop of *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}
was:
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}
> 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 *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)
