Confirmed users
95
edits
Telemetry/LongitudinalExamples: Difference between revisions
Jump to navigation
Jump to search
→Maps: add maps example
Gfritzsche (talk | contribs) (Simplifying examples) |
Gfritzsche (talk | contribs) (→Maps: add maps example) |
||
| Line 20: | Line 20: | ||
=== Maps === | === Maps === | ||
Some fields like <code>active_addons</code> or <code>user_prefs</code> are handled as maps, on which you can use the <code>[]</code> operator and special functions: | |||
WITH adp AS | |||
(SELECT active_addons[1]['{d10d0bf8-f5b5-c8b4-a8b2-2b9879e08c5d}'] | |||
IS NOT null AS has_adblockplus | |||
FROM longitudinal_v20160229) | |||
SELECT has_adblockplus, count(*) AS count | |||
FROM adp GROUP BY 1 ORDER BY 2 DESC | |||
Links: | Links: | ||