Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH actions AS (
- SELECT
- submission_date_s3,
- split_part(locale, '-', 1) as locale,
- e.t.timestamp,
- e.t.category,
- e.t.method,
- e.t.object,
- e.t.value
- FROM
- telemetry_mobile_event_parquet
- CROSS JOIN
- UNNEST(events) AS e(t)
- WHERE
- submission_date_s3 >= '20180125' AND app_name = 'Fennec' AND os = 'iOS'
- AND e.t.category = 'action' AND e.t.method = 'scan'
- )
- SELECT
- submission_date_s3,
- object,
- COUNT(*) as count
- FROM
- actions
- GROUP BY
- submission_date_s3, object
- ORDER BY
- submission_date_s3 ASC
Add Comment
Please, Sign In to add comment