[
https://issues.apache.org/jira/browse/KYLIN-5267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Liu Zhao updated KYLIN-5267:
----------------------------
Description: Kylin4 queries use Spark, and the result data will be sent to
the driver (that is, query service). If the user's SQL returns a large data
set, it may cause the query oom to be unavailable. To solve this problem, can
we provide a means for users to enforce limit when SQL has no limit to protect
services. I am here https://issues.apache.org/jira/browse/KYLIN-2649 You can
see the idea above, but can reduce the limit on the SQL structure？ (was:
Kylin4查询使用spark，结果数据会被发送到driver（即query上），如果用户的sql会返回极大的数据集，那么就可能导致query
oom从而服务不可用。针对这个问题，我们能否提供一种手段给用户，让其可以对没有limit的语句强制limit，以保护服务。我在
https://issues.apache.org/jira/browse/KYLIN-2649 上看到这个思路，但是否可以对sql结构再降低些限制呢)
> force limit to protect the service when SQL has no limit
> --------------------------------------------------------
>
> Key: KYLIN-5267
> URL: https://issues.apache.org/jira/browse/KYLIN-5267
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: v4.0.1
> Reporter: Liu Zhao
> Priority: Minor
>
> Kylin4 queries use Spark, and the result data will be sent to the driver
> (that is, query service). If the user's SQL returns a large data set, it may
> cause the query oom to be unavailable. To solve this problem, can we provide
> a means for users to enforce limit when SQL has no limit to protect services.
> I am here https://issues.apache.org/jira/browse/KYLIN-2649 You can see the
> idea above, but can reduce the limit on the SQL structure？
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
