WITH data1 as (
SELECT explode(array(1,2,3,4,5)) as id
),
data2 as (
SELECT explode(array(1,3,5,6,8)) as id
),
bloom as (
SELECT bloom(id) as bf
FROM data1
)
SELECT
l.*
FROM
data2 l
CROSS JOIN bloom r
WHERE
bloom_contains_any(r.bf, array(l.id))
WhereOS is a data innovation platform and service.
For teams and businesses who want to get more value out of data – WhereOS minimizes your effort and maximizes your results.
If you wish discuss with us, please contact us through support@eaglepeaks.com or call us +358 50 486 9257.
© WhereOS 2021 All rights reserved
