HappenLee opened a new issue #4986: URL: https://github.com/apache/incubator-doris/issues/4986
**Is your feature request related to a problem? Please describe.** Now, Doris's **OLAP_SCAN_NODE can push the conjuncts condition to the storage engine**. But after push it down to storage engine, **the conditions still need to be filtered in the OLAP_SCANNER**. It's is a very unreasonable way. Therefore, we need to figure out the filtering conditions that have been pushed down to the storage engine. Delete these pushed down conditions on the OLAP SCANNER. We should not waste CPU resources on the conditions that have been filtered. **Describe the solution you'd like** I Had Do **POC** in the data of SSB: ``` select * from customer where C_NATION = "CHINA" order by C_CUSTKEY limit 10, 15; ``` There are 3000W rows of data | Cost Time | Origin Doris | Delete Push Down Conjuncts | | :-----: | :----: | :----: | | | 5.2s | 4.3s | It's about 20% performance improvement ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
