“WITH yourTable AS ( SELECT '192.168.1.1' AS ip, [('apple', 'red'), ('orange', 'orange'), ('grape', 'purple')] AS cookie UNION ALL SELECT '192.168.1.2', [('abc', 'xyz'), ('orange', 'orange'), ('orange', 'orange')] ) SELECT ip FROM yourTable t WHERE ( ('grape', 'purple') IN UNNEST(t.cookie) AND ('o
“WITH yourTable AS ( SELECT '192.168.1.1' AS ip, [('apple', 'red'), ('orange', 'orange'), ('grape', 'purple')] AS cookie UNION ALL SELECT '192.168.1.2', [('abc', 'xyz'), ('orange', 'orange'), ('orange', 'orange')] ) SELECT ip FROM yourTable t WHERE ( ('grape', 'purple') IN UNNEST(t.cookie) AND ('o
このブックマークにはスターがありません。
最初のスターをつけてみよう！
How do I find elements in an array in BigQuery
1 人がブックマーク・1 件のコメント
＼ コメントが サクサク読める アプリです ／