[
https://issues.apache.org/jira/browse/KYLIN-3319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 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)
