taiyang-li commented on issue #9176: URL: https://github.com/apache/incubator-gluten/issues/9176#issuecomment-2772108751
Another performance test: ``` sql select count(id / 2) filter (where id % 2 = 0) from range(100000000); 1 row selected (1.023 seconds) 1 row selected (1.047 seconds) 1 row selected (1.03 seconds) set spark.gluten.sql.columnar.backend.ch.runtime_config.enable_aggregate_if_to_filter=true select count(if(id % 2= 0 , id / 2, null)) from range(100000000); 1 row selected (1.06 seconds) 1 row selected (1.062 seconds) 1 row selected (1.048 seconds) set spark.gluten.sql.columnar.backend.ch.runtime_config.enable_aggregate_if_to_filter=false select count(if(id % 2= 0 , id / 2, null)) from range(100000000); 1 row selected (1.205 seconds) 1 row selected (1.203 seconds) 1 row selected (1.18 seconds) ``` -- 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]
