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:34:00 UTC

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

zhaoliu created KYLIN-5267:
------------------------------

             Summary: 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


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)