JustinMars1 opened a new issue #7169: URL: https://github.com/apache/incubator-doris/issues/7169
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version apache/incubator-doris:build-env-1.4.1 ### What's Wrong? ERROR 1064 (HY000): errCode = 2, detailMessage = Memory exceed limit. New partitioned Aggregation in spill Backend: 172.21.16.8, fragment: 67ef448d62ff4cac-999c74988410454a Used: 21566009856, Limit: -1. You can change the limit by session variable exec_mem_limit. but already SET exec_mem_limit = 120G; condition : 1. There are 800 million single tables,150GB SQL : select uuid,count(1) from table_a group by uuid limit 100; ### What You Expected? sql get rigtht result ### How to Reproduce? _No response_ ### Anything Else? no ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
