kaka11chen opened a new pull request, #19106: URL: https://github.com/apache/doris/pull/19106
# Proposed changes Issue Number: About #19038, we found in this case, `l_orderkey` has many nulls, so we can filter it by null count statistics in the row group and page level, then it can improve a lot of performance in this case. ## Test Result: Before opt: ``` mysql> select l_quantity from test_external_catalog_hive.tpch_1000_parquet.lineitem where l_orderkey = 599614241 and l_partkey = 59018738 and l_suppkey = 1518744 limit 2; +------------+ | l_quantity | +------------+ | 16.00 | +------------+ 1 row in set (41.95 sec) ``` After opt: ``` mysql> select l_quantity from test_external_catalog_hive.tpch_1000_parquet.lineitem where l_orderkey = 599614241 and l_partkey = 59018738 and l_suppkey = 1518744 limit 2; +------------+ | l_quantity | +------------+ | 16.00 | +------------+ 1 row in set (4.32 sec) ``` ## Problem summary Describe your changes. ## Checklist(Required) * [ ] Does it affect the original behavior * [ ] Has unit tests been added * [ ] Has document been added or modified * [ ] Does it need to update dependencies * [ ] Is this PR support rollback (If NO, please explain WHY) ## Further comments If this is a relatively large or complex change, kick off the discussion at [[email protected]](mailto:[email protected]) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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]
