CODEWITHSUNDEEP
firebasegoogle-bigquery
Kasper Nielsen
Kasper Nielsen

Reputation: 3

Bigquery UNNEST ARRAYS

I wanna list of item_name, but contentType must be "POI"

[1] https://i.sstatic.net/gfTez.jpg

select param.item_name from 'dataset', 
UNNEST(event_params) AS param
where event_name  = "select_content" AND param.value.string_value = "POI"

Upvotes: 0

Views: 185

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172993

Below is for BigQuery Standard SQL 

#standardSQL
SELECT 
  ( SELECT value.string_value
    FROM UNNEST(event_params) param
    WHERE key = 'item_name'
  ) AS item_name
FROM `project.dataset.table`
WHERE (
  SELECT COUNT(1) FROM UNNEST(event_params) param
  WHERE (key, value.string_value) = ('content_type', 'POI') OR key = 'item_name'
  ) = 2

Upvotes: 1

Related Questions