You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "linehrr (via GitHub)" <gi...@apache.org> on 2025/01/09 20:00:03 UTC
[I] SQL query planner crash when subquery combined with limit and case when (druid)
linehrr opened a new issue, #17615:
URL: https://github.com/apache/druid/issues/17615
### Affected Version
27.0.0
### Description
we have a table like this:

--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
Re: [I] SQL query planner crash when subquery combined with limit and case when (druid)
Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm closed issue #17615: SQL query planner crash when subquery combined with limit and case when
URL: https://github.com/apache/druid/issues/17615
--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
Re: [I] SQL query planner crash when subquery combined with limit and case when (druid)
Posted by "gianm (via GitHub)" <gi...@apache.org>.
gianm commented on issue #17615:
URL: https://github.com/apache/druid/issues/17615#issuecomment-2776669873
I tried to reproduce this against the latest version of Druid, using a `wikipedia` example table with some column names changed. (I changed `PixelKey` to `countryName` and `AdvertiserId` to `page`.) It ran OK. It is possible this issue has been fixed since Druid 27, which is quite old.
If you still run into this issue in the latest version, please let us know. Please also help us debug by including text rather than pictures of queries. I had to retype the query to try it out. Thank you!
--
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.
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org