lipenghao1216 opened a new issue, #30087: URL: https://github.com/apache/doris/issues/30087
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.2 ### What's Wrong? i have a unique model table, 600w rows,when i use select * from table limit 7000000, query failed caused by memory exceed limit; use mem_tracker can see query use large memory  my be server still have 3g available memory i think a sql without group by order by .. just scan full table data should not use too many memory, because be need not to load all data into memory from disk ，then send to client my table ddl and query profile [profile_1705491397004.txt](https://github.com/apache/doris/files/13971586/profile_1705491397004.txt) [ddl.txt](https://github.com/apache/doris/files/13971591/ddl.txt) ### What You Expected? select * from table can execute successfully without using large memory ### How to Reproduce? be without rich available memory, like 3g table uncompressed data size exceed 3g select * from table ### Anything Else? _No response_ ### 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]
