[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #1892: Enhance the speed of avg function

[GitBox <gi...@apache.org>]

EmmyMiao87 opened a new issue #1892: Enhance the speed of avg function
URL: https://github.com/apache/incubator-doris/issues/1892
 
 
   **Is your feature request related to a problem? Please describe.**
   Now, the avg function in query need to be converted into sum/count. The speed of avg function is slower than a single sum function. 
   
   For 70 million lines, 
   
   CREATE TABLE `store_sales_duplicate` (
     `ss_item_sk` int(11) NOT NULL COMMENT "",
     `ss_ticket_number` int(11) NOT NULL COMMENT "",
     `ss_sold_date_sk` int(11) NULL COMMENT "",
     `ss_sold_time_sk` int(11) NULL COMMENT "",
     `ss_customer_sk` int(11) NULL COMMENT "",
     `ss_cdemo_sk` int(11) NULL COMMENT "",
     `ss_hdemo_sk` int(11) NULL COMMENT "",
     `ss_addr_sk` int(11) NULL COMMENT "",
     `ss_store_sk` int(11) NULL COMMENT "",
     `ss_promo_sk` int(11) NULL COMMENT "",
     `ss_quantity` int(11) NULL COMMENT "",
     `ss_wholesale_cost` decimal(7, 2) NULL COMMENT "",
     `ss_list_price` decimal(7, 2) NULL COMMENT "",
     `ss_sales_price` decimal(7, 2) NULL COMMENT "",
     `ss_ext_discount_amt` decimal(7, 2) NULL COMMENT "",
     `ss_ext_sales_price` decimal(7, 2) NULL COMMENT "",
     `ss_ext_wholesale_cost` decimal(7, 2) NULL COMMENT "",
     `ss_ext_list_price` decimal(7, 2) NULL COMMENT "",
     `ss_ext_tax` decimal(7, 2) NULL COMMENT "",
     `ss_coupon_amt` decimal(7, 2) NULL COMMENT "",
     `ss_net_paid` decimal(7, 2) NULL COMMENT "",
     `ss_net_paid_inc_tax` decimal(7, 2) NULL COMMENT "",
     `ss_net_profit` decimal(7, 2) NULL COMMENT ""
   ) ENGINE=OLAP
   DUPLICATE KEY(`ss_item_sk`, `ss_ticket_number`)
   DISTRIBUTED BY HASH(`ss_item_sk`, `ss_ticket_number`) BUCKETS 100
   PROPERTIES (
   "storage_type" = "COLUMN"
   );
   
   mysql> select avg(ss_sales_price) from store_sales;
   +-----------------------+
   | avg(`ss_sales_price`) |
   +-----------------------+
   |          37.873307747 |
   +-----------------------+
   1 row in set (5.73 sec)
   
   mysql> select sum(ss_sales_price) from store_sales_duplicate;
   +-----------------------+
   | sum(`ss_sales_price`) |
   +-----------------------+
   |          2761762504.1 |
   +-----------------------+
   1 row in set (3.44 sec)
   
   **Describe the solution you'd like**
   The avg operator has been implemented in be while fe does not support this operator.
   Avg operator should be supported in fe and it will improve the speed of avg function.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org