HappenLee opened a new pull request, #42375:
URL: https://github.com/apache/doris/pull/42375

   support cache tablets aggregate result
   
   for example
   
   SQL 1:
   ```sql
   select key, sum(value)
   from tbl
   where dt between '2024-08-01' and '2024-08-10'
   group by key
   ```
   
   SQL 2:
   ```sql
   select key, sum(value)
   from tbl
   where dt between '2024-08-5' and '2024-08-15'
   group by key
   ```
   
   SQL 1 will update the tablets aggregate result which partition between 
'2024-08-01' and '2024-08-10'.
   Then SQL 2 will reuse the tablets aggregate which partition between 
'2024-08-05' and '2024-08-10', and compute aggregate which partition between 
'2024-08-11' and '2024-08-15'
   
   We only support simple aggregate which not contains join with runtime 
filter, at present.
   
   ```sql
   set enable_query_cache=true;
   ```
   
   


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

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

Reply via email to