[jira] [Created] (KYLIN-4189) Prevent abnormal CPU usage by limiting lookup table's rows

["Temple Zhou (Jira)" <ji...@apache.org>]

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)