kaka11chen opened a new issue #10842:
URL: https://github.com/apache/druid/issues/10842
A kind of nested groupby sql will caused the Infinite loop.
### Affected Version
all versions.
### Description
This kind of nested groupby sql will caused the infinite loop.
`
SELECT
dim2,
dim1,
SUM (inner_sum) AS sum_m1
FROM
(
SELECT
dim2,
dim1,
SUM (m1) AS inner_sum
FROM
foo
GROUP BY
dim2,
dim1
)
GROUP BY
dim2,
dim1
ORDER BY
dim2,
dim1
`
Some workarounds:
- Add `limit N` at last.
- Reorder group by dimensions by alphabetical order. In this case is `group
by dim1, dim2`.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
