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]

Constructs a BloomFilter by aggregating a set of keys bloom(string key) Platforms: WhereOS, Spark, Hive

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:

binary(expr) – Casts the value `expr` to the target data type `binary`. Platforms: WhereOS, Spark,

bit_length(expr) – Returns the bit length of string data or number of bits of binary