Description
Hi, all.
I found that limit in the web UI seems not behaving as expected.
When I run a query like the follows:
SELECT SUM(col3) AS col4, SUM(col5) AS total_col5, col1 FROM ( SELECT col1, col2, MAX(col3) AS col3, COUNT(*) AS col5 FROM db.table WHERE col6 = 'somestring' GROUP BY col1, col2 ) GROUP BY col1
When I specify the limit as 50, the result has 19 records, and when I specify the limit as 500000, there are 90+ records in the result and each record has higher col4 and total_col5.
But for query that doesn't have subquery, the result remains the same no matter how I change the limit.
I guess for the query with subquery, limit somehow limits the number of the result from the inner query instead of the result of the outer query.
Attachments
Attachments
Issue Links
- is related to
-
KYLIN-3722 Error Limit Push Down in Join Related Query
- Closed