kobe6th opened a new issue, #34759: URL: https://github.com/apache/doris/issues/34759
### 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? nereids planner slower than old planner ### What You Expected? fix this issue ### How to Reproduce? ` CREATE TABLE `test_tbl` ( `id` VARCHAR(200) NULL, `create_time` DATETIME NULL, `amount` DECIMAL(21, 10) NULL, `num` VARCHAR(1020) NULL ) ENGINE=OLAP UNIQUE KEY(`id`, `create_time`) COMMENT 'OLAP' DISTRIBUTED BY HASH(`id`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 3" ); SELECT count(id) FROM ( SELECT id, sum(amount) AS am, count(DISTINCT num) AS num FROM test_tbl GROUP BY id ) s1 WHERE 1 = 1 AND am >= 10 AND am <= 1000000 AND num >= 2 AND num <= 10000; ` 20000000 records in test_tbl with `set enable_nereids_planner=true`, cost 11.40s with `set enable_nereids_planner=false`, cost 4.66s ### 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: 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
