clickhoues groupBitmapAnd

 

 

 1 SELECT
 2 groupBitmapAnd(uv)
 3 ,groupBitmapOr(uv)
 4 ,bitmapToArray(groupBitmapAndState(uv))
 5 ,arraySort(bitmapToArray(groupBitmapAndState(uv))) 
 6 ,arraySort(bitmapToArray(groupBitmapOrState(uv))) 
 7 FROM (
 8 SELECT '1' AS id , bitmapBuild(cast([1,2,3,4,5,6,7,8,9,10] as Array(UInt32))) AS uv
 9 UNION ALL  SELECT '1' AS id , bitmapBuild(cast([6,7,8,9,10,11,12,13,14,15] as Array(UInt32))) AS uv
10 UNION ALL SELECT '1' AS id , bitmapBuild(cast([1,2,4,6,8,10,12] as Array(UInt32))) AS uv
11 ) t
12 
13 
14 
15 SELECT
16 groupBitmapAnd(uv) "交集"
17 ,arraySort(bitmapToArray(groupBitmapAndState(uv))) "交集_list"
18 ,groupBitmapOr(uv) "并集"
19 ,arraySort(bitmapToArray(groupBitmapOrState(uv)))  "并集_list"
20 FROM (
21 SELECT '1' AS id , bitmapBuild([1,2,3,4,5,6,7,8,9,10]) AS uv
22 UNION ALL  SELECT '1' AS id , bitmapBuild([6,7,8,9,10,11,12,13,14,15]) AS uv
23 UNION ALL SELECT '1' AS id , bitmapBuild([1,2,4,6,8,10,12]) AS uv
24 ) t

 

posted @ 2021-12-01 16:23  linbo.yang  阅读(171)  评论(0)    收藏  举报