You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "May Zhou (JIRA)" <ji...@apache.org> on 2018/11/15 13:05:00 UTC
[jira] [Commented] (KYLIN-3319) exceeds threshold 5000000 while
executing SQL
[ https://issues.apache.org/jira/browse/KYLIN-3319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16688010#comment-16688010 ]
May Zhou commented on KYLIN-3319:
---------------------------------
I found a user also encountered this problem and he may turned to this JIRA for some references.
I think it may be a workaround to increase the value of `kylin.query.max-return-row`,which specifies the maximum number of rows returned by the query and the default value is 5000000.
More configuration information can be referred in Kylin's Document: [https://kylin.apache.org/docs/install/configuration.html]
> exceeds threshold 5000000 while executing SQL
> ---------------------------------------------
>
> Key: KYLIN-3319
> URL: https://issues.apache.org/jira/browse/KYLIN-3319
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.3.0
> Reporter: cc
> Priority: Blocker
> Attachments: image.png, sql_limit_result.png
>
>
> {color:#d04437}hello,what is the reason of the errors?{color}
> {color:#d04437}Query returned 5008662 rows exceeds threshold 5000000 while executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 50000"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)