[GitHub] [incubator-doris] yangzhg opened a new pull request #3278: Optimzie where cluase when have duplicate ors

Tue, 07 Apr 2020 23:36:45 -0700 

yangzhg opened a new pull request #3278: Optimzie where cluase when have 
duplicate ors
URL: https://github.com/apache/incubator-doris/pull/3278
 
 
   improve performent describe in #3245 
   for example sql
   ```
   select
      avg(ss_quantity),
      avg(ss_ext_sales_price),
      avg(ss_ext_wholesale_cost),
      sum(ss_ext_wholesale_cost)
   from
      store_sales,
      customer_address
   where
      (
         (
            ss_addr_sk = ca_address_sk
            and ca_country = 'United States'
            and ca_state in ('CO', 'IL', 'MN')
            and ss_net_profit between 100
            and 200
         )
         or (
            ss_addr_sk = ca_address_sk
            and ca_country = 'United States'
            and ca_state in ('OH', 'MT', 'NM')
            and ss_net_profit between 150
            and 300
         )
         or (
            ss_addr_sk = ca_address_sk
            and ca_country = 'United States'
            and ca_state in ('TX', 'MO', 'MI')
            and ss_net_profit between 50
            and 250
         )
      )
   ```
   now can be finished in 20s
   
![image](https://user-images.githubusercontent.com/9098473/78752220-422d0480-79a6-11ea-9f30-0c0a7f56491a.png)
   
   

----------------------------------------------------------------
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]

Reply via email to