BITMAP_AND
更新时间：2025-10-16
描述
计算两个及以上输入的 BITMAP 的交集，返回新的 BITMAP.
语法
SQL
1BITMAP_AND(<bitmap>, <bitmap>,[, <bitmap>...])参数
| 参数 | 说明 |
|---|---|
<bitmap> |
被求交集的原 BITMAP 之一 |
返回值
返回一个 BITMAP
- 当参数存在空值时，返回 NULL
举例
SQL
1select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
Text
1+-----------------------------------------------------------------------------------------------------------------------+
2| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
3+-----------------------------------------------------------------------------------------------------------------------+
4| 1,2 |
5+-----------------------------------------------------------------------------------------------------------------------+
SQL
1select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
Text
1+---------------------------------------------------------------------------------------------------------------------------------------+
2| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), bitmap_empty())) |
3+---------------------------------------------------------------------------------------------------------------------------------------+
4| |
5+---------------------------------------------------------------------------------------------------------------------------------------+
SQL
1select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
Text
1+-----------------------------------------------------------------------------------------------------------------------------+
2| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'), bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), NULL)) |
3+-----------------------------------------------------------------------------------------------------------------------------+
4| NULL |
5+-----------------------------------------------------------------------------------------------------------------------------+