[
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)
