LoginSignup
19
4

More than 5 years have passed since last update.

@shiozaki(健弘 塩崎)in株式会社ZOZO

BigQuery Standard SQLである要素が配列中に含まれているかどうかを判定する方法

Posted at

ある要素が配列の中に含まれているかどうかを判定するUDF関数を作ってみました。

#standardSQL
CREATE TEMPORARY FUNCTION ARRAY_INT64_INCLUDE(arr ARRAY<INT64>, val INT64)
RETURNS BOOL AS ((
  SELECT LOGICAL_OR(elem = val) FROM UNNEST(arr) as elem
));

SELECT ARRAY_INT64_INCLUDE([1, 2, 3], 4)
19
4
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
19
4