zengzhijie opened a new issue, #33104: URL: https://github.com/apache/doris/issues/33104
### 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.1 ### What's Wrong? 现有一个doris的数据表 3个亿左右的数据量，例如 select * from temp where device_no in （"1","2",..."10001"），会执行报错，其中的参数是有由户选择的的，也没法事先建临时表和用子查询；同时也是分页查询，如果使用代码进行逻辑拆分查询，又会导致多次查询数据库，存在效率问题；所以对于这种情况该如何去优化，有什么更好的方案去解决呢；还是说从改业务层面呢;什么方式都试过了，没有好的可行方案。还希望广大朋友能解答一下这种业务场景下如何去优化改良。 ### What You Expected? 1 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### 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: [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]
