Confirmed users
207
edits
Telemetry/LongitudinalExamples: Difference between revisions
Jump to navigation
Jump to search
added some blocklist examples
Gfritzsche (talk | contribs) (adding doc links for array and map functions) |
(added some blocklist examples) |
||
| Line 23: | Line 23: | ||
Links: | Links: | ||
* [https://prestodb.io/docs/current/functions/map.html Documentation on map functions] | * [https://prestodb.io/docs/current/functions/map.html Documentation on map functions] | ||
=== Examples === | |||
* Blocklist URLs (extensions.blocklist.url): | |||
SELECT bl, COUNT(bl) | |||
FROM | |||
(SELECT client_id, | |||
element_at(settings, 1).user_prefs['extensions.blocklist.url'] AS bl | |||
FROM longitudinal_v20160229) | |||
GROUP BY bl | |||
* Blocklist enabled/disabled (extensions.blocklist.enabled) count: | |||
SELECT bl, COUNT(bl) | |||
FROM | |||
(SELECT client_id, | |||
element_at(settings, 1).blocklist_enabled AS bl | |||
FROM longitudinal_v20160229) | |||
GROUP BY bl | |||