trikker opened a new issue, #28868: URL: https://github.com/apache/doris/issues/28868
### 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.3 ### What's Wrong? The SQL is too slow and it executes fast after I rewrite the SQL. The original SQL and rewrited SQL and table structure are in attatchment file because they are too long and cannot be written in issue. [slow_sql.log](https://github.com/apache/doris/files/13749640/slow_sql.log) ### What You Expected? The query plan should realize that the field stmt is too large and should read the field after fitering the top 100 rows by where condition. That is something like "late materialization". Doris's document has introduction about late materialization in https://doris.apache.org/zh-CN/docs/query-acceleration/join-optimization/doris-join-optimization?_highlight=%E5%BB%B6%E8%BF%9F&_highlight=%E7%89%A9%E5%8C%96#runtime-filter--join-%E4%BC%98%E5%8C%96 ### How to Reproduce? It is easy to reproduce but my data are too large and cannot upload the data. ### Anything Else? How can I set variables or parameters to make the SQL execute fast? ### Are you willing to submit PR? - [ ] 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
