Temple Zhou created KYLIN-4189:
----------------------------------
Summary: Prevent abnormal CPU usage by limiting lookup table's rows
Key: KYLIN-4189
URL: https://issues.apache.org/jira/browse/KYLIN-4189
Project: Kylin
Issue Type: Improvement
Components: Query Engine
Affects Versions: v2.6.0, v2.5.0, v2.4.0
Reporter: Temple Zhou
Assignee: Temple Zhou
Although lookup table size is limited, snapshot table with too many rows will
break the server.
Such as:
{code:sql}
select
dim.b
FROM
fact
INNER JOIN dim ON fact.B = dim.B
group by
dim.b
{code}
If the number of rows in column dim.B is million, the query will execute for
dozens seconds and the CPU utilization is extremely high.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
