用bitmap查找多次聚合的合并结果

WITH 
    (
    SELECT
      bitmapBuild(groupArray(u)) 
    FROM
      (SELECT toUInt64OrZero(user_id) as u, event_name, count() AS cnt FROM events WHERE event_name = '$ProductDetailsFreeRent' AND event_date = '2022-01-24' GROUP BY user_id, event_name HAVING cnt > 10 ) 
    ) AS a,
    (
    SELECT
      bitmapBuild(groupArray(u)) 
    FROM
      (SELECT toUInt64OrZero(user_id) as u, event_name, count() AS cnt FROM events WHERE event_name = '$VisitNonLeaseDetailPage' AND event_date = '2022-01-24' GROUP BY user_id, event_name HAVING cnt > 10 ) 
    ) AS b
    SELECT bitmapToArray (bitmapOr ( a, b )) AS c