Telemetry/LongitudinalExamples: Difference between revisions

Jump to navigation Jump to search
added some blocklist examples
(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
Confirmed users
207

edits

Navigation menu