morrySnow commented on code in PR #1825: URL: https://github.com/apache/doris-website/pull/1825#discussion_r1919519244
########## docs/sql-manual/sql-functions/aggregate-functions/intersect-count.md: ########## @@ -30,26 +30,28 @@ under the License. Calculate the intersection of two or more bitmaps Usage: intersect_count(bitmap_column_to_count, filter_column, filter_values ...) Example: intersect_count(user_id, event, 'A', 'B', 'C'), meaning find the intersect count of user_id in all A/B/C 3 bitmaps +Calculate the intersection count of elements in bitmap_column that match column_to_filter within filter_values, i.e., bitmap intersection count. ### example ``` -MySQL [test_query_qa]> select dt,bitmap_to_string(user_id) from pv_bitmap where dt in (3,4); -+------+-----------------------------+ -| dt | bitmap_to_string(`user_id`) | -+------+-----------------------------+ -| 4 | 1,2,3 | -| 3 | 1,2,3,4,5 | -+------+-----------------------------+ -2 rows in set (0.012 sec) - -MySQL [test_query_qa]> select intersect_count(user_id,dt,3,4) from pv_bitmap; -+----------------------------------------+ -| intersect_count(`user_id`, `dt`, 3, 4) | -+----------------------------------------+ -| 3 | -+----------------------------------------+ -1 row in set (0.014 sec) +mysql [test]>select dt,bitmap_to_string(user_id) from pv_bitmap; Review Comment: 不要带prompt ```suggestion elect dt,bitmap_to_string(user_id) from pv_bitmap; ``` ########## docs/sql-manual/sql-functions/aggregate-functions/intersect-count.md: ########## @@ -30,26 +30,28 @@ under the License. Calculate the intersection of two or more bitmaps Usage: intersect_count(bitmap_column_to_count, filter_column, filter_values ...) Example: intersect_count(user_id, event, 'A', 'B', 'C'), meaning find the intersect count of user_id in all A/B/C 3 bitmaps +Calculate the intersection count of elements in bitmap_column that match column_to_filter within filter_values, i.e., bitmap intersection count. ### example Review Comment: 使用二级标题 -- 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
