[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=16827958#comment-16827958
]
hejian commented on KYLIN-3319:
---
hi [~zhao jintao], waiting to be solved fundamentally, this issue offten
happens when aggregation on the high-cardinality along with a longer day span.
In my case, a dimension with 3million cardinality called seller_id,
{code:java}
select seller_id, sum(volume) as count_num from tab_orders where
day_id>='2019-04-07' and day_id<2019-04-27 group by seller_id order by
count_num desc offset 0 limit 10{code}
I think it relates to the *cardinality(seller_id)* and *cardinality(day_id)*
and ** the corresponding *shards*?
how to determine the suitable value to 'kylin.query.max-return-row' or make
work well
any better solution?
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=16823775#comment-16823775
]
hejian commented on KYLIN-3319:
---
Can the excessive segments aslo result in that issue?
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=16784334#comment-16784334
]
zhao jintao commented on KYLIN-3319:
Hi May Zhou; What's May Zhou's view is currect. You can set
kylin.query.max-return-row
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=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 500.
More configuration information can be referred in Kylin's Document:
[https://kylin.apache.org/docs/install/configuration.html]
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=16658895#comment-16658895
]
Sachin Aggarwal commented on KYLIN-3319:
I am also facing this error, In my case I am getting this error from dimension
table. I have join with product table with is very big and I am filtering it in
subquery but still row count is crossing the limit
for eg dummy query is :
SELECT
A, B, C, count(1)
FROM
DB.Fact T1
INNER JOIN
(Select C,D from DB.Dim where and E IN (1,2,3.)) T2
ON (T1.C=T2.C)
WHERE
T1.Z='WM'
GROUP BY
A,B;
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=16541636#comment-16541636
]
翟娜 commented on KYLIN-3319:
---
hi, [~ss1]
I couldn't reproduce this problem.
With the similar sql statements, I got the following results：
!sql_limit_result.png!
So could you provide more detail about this issue？Thanks
> exceeds threshold 500 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 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[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=16431936#comment-16431936
]
Qiu Yi commented on KYLIN-3319:
---
{{Set kylin.dictionary.max.cardinality}} in conf/kylin.properties to a bigger
value (default is 500).
You can get more information by click the url.
http://kylin.apache.org/blog/2016/05/29/raw-measure-in-kylin/
> exceeds threshold 500 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
>
>
> {color:#d04437}hello,what is the reason of the errors?{color}
> {color:#d04437}Query returned 5008662 rows exceeds threshold 500 while
> executing SQL: "select * from USER_FREQ_DAY_TEST LIMIT 5"{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
