SQL Functions

bloom_contains_any(string bloom, string key) or bloom_contains_any(string bloom, array keys)- Returns true if the bloom filter

Returns the logical NOT of a bloom filters; representing the set of values NOT in

Returns the logical OR of two bloom filters; representing the intersection of values in either

Returns the logical AND of two bloom filters; representing the intersection of values in both

Returns true if the referenced bloom filter contains the key.. bloom_contains(string key, string bloomfilter) Platforms:

bits_or(array b1, array b2, ..) – Returns a logical OR given bitsets SELECT unbits(bits_or(to_bits(array(1,4)),to_bits(array(2,3)))); [1,2,3,4]