gianm commented on issue #17958: URL: https://github.com/apache/druid/issues/17958#issuecomment-2861881721
Do you have a way to reproduce this (or something similar) with a dataset and query you can share? Without the ability to reproduce the behavior, it may be difficult to get to the bottom of it. Certainly, adding the `ROW_NUMBER() OVER ( ORDER BY sale_revenue DESC ) AS row_num` causes the "SQL 2" query to become a subquery itself. But if it only returns 214 results then that shouldn't cause you to trigger the `maxSubqueryRows` limit, unless you were already very close. Examining the native query generated by the SQL layer for the two different queries may provide some clues (try `EXPLAIN PLAN FOR` to see it). -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
