You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "zhaoliu (Jira)" <ji...@apache.org> on 2022/09/16 14:38:00 UTC

[jira] [Commented] (KYLIN-5267) force limit to protect the service when SQL has no limit

    [ https://issues.apache.org/jira/browse/KYLIN-5267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17605865#comment-17605865 ] 

zhaoliu commented on KYLIN-5267:
--------------------------------

如果有需要，我可以修复此问题

> 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: zhaoliu
>            Priority: Minor
>
> Kylin4查询使用spark，结果数据会被发送到driver（即query上），如果用户的sql会返回极大的数据集，那么就可能导致query oom从而服务不可用。针对这个问题，我们能否提供一种手段给用户，让其可以对没有limit的语句强制limit，以保护服务。我在 https://issues.apache.org/jira/browse/KYLIN-2649 上看到这个思路，但是否可以对sql结构再降低些限制呢



--
This message was sent by Atlassian Jira
(v8.20.10#820010)