yangyichao-mango opened a new issue, #2538:
URL: https://github.com/apache/doris-website/issues/2538

   - Page Link: 
https://doris.apache.org/zh-CN/docs/sql-manual/sql-functions/aggregate-functions/bitmap-union-count
   
   - Version: 2.1
   
   - Reason: 可以加一个最佳实践,如下
   ```sql
   -- 
在窗口函数中,bitmap_union_count由于bitmap_count(bitmap_union(x))可以得到更优的性能,推荐使用bitmap_union_count
   
   -- bitmap_count(bitmap_union(x)) 结合窗口函数
     BITMAP_COUNT(
       BITMAP_UNION(1min_bitmap) OVER (
         ORDER BY
           metric_minute 
         ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
       )
     )
   
   -- bitmap_union_count 结合窗口函数
     BITMAP_UNION_COUNT(1min_bitmap) OVER (
       ORDER BY
         metric_minute 
       ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
     )
   ```
   
   -   May I contribute to this pull request? Our company has been frequently 
using Doris lately. If given the chance, I would also like to gradually become 
involved in the community.(如果确认该Issue的话,可以由我来提交PR吗,我很希望参与到doris社区当中)
   
   - ScreenShot:
   
![Image](https://github.com/user-attachments/assets/a3bdfade-229d-4d19-887b-cfa75b94835c)


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

Reply via email to