EmmyMiao87 edited a comment on issue #1892: Enhance the speed of avg function URL: https://github.com/apache/incubator-doris/issues/1892#issuecomment-535760095 After this pr, the speed of avg function is similar to sum function. For 70 million lines: The avg function is 40% faster than before. mysql> select avg(ss_sales_price) from store_sales_duplicate; +-----------------------+ | avg(`ss_sales_price`) | +-----------------------+ | 37.873307747 | +-----------------------+ 1 row in set (3.74 sec) while the speed of sum function is mysql> select sum(ss_sales_price) from store_sales_duplicate; +-----------------------+ | sum(`ss_sales_price`) | +-----------------------+ | 2761762504.1 | +-----------------------+ 1 row in set (3.42 sec)
---------------------------------------------------------------- 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] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
