lijie749808 opened a new issue, #15343: URL: https://github.com/apache/druid/issues/15343
Broker OOM Error During SQL Execution. ### Affected Version 0.22.1 ### Description An Out of Memory (OOM) error occurs when executing the SQL statement shown in the attached image. Post-OOM analysis with Eclipse MAT on the heap dump revealed thread information, also attached as an image below.   The suspected cause of the issue is the combination of `time_format(time_parse('2023-11-01'),'yyyy-MM-DD')`, `GROUP BY`, and `ORDER BY` clauses. The date format string "yyyy-MM-DD" seems to be incorrect, potentially leading to a parsing error in `time_format(time_parse('2023-11-01'),'yyyy-MM-DD')`. This, coupled with possibly incorrect filtering in the `WHERE` clause and the `ORDER BY` operation, might be contributing to the problem during execution plan analysis. -- 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]
