Telemetry/LongitudinalExamples: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
m (→‎Arrays: use subscript operator)
(Deprecate wiki based d10n)
 
(19 intermediate revisions by 5 users not shown)
Line 1: Line 1:
Note: There is good background in the [https://gist.github.com/vitillo/627eab7e2b3f814725d2 example notebook] for the longitudinal data set.
This document is now hosted here:
https://github.com/mozilla/telemetry-batch-view/blob/master/docs/longitudinal_examples.md


Get an overview of the longitudinal data table:
Wiki pages linking to this dead page:
describe longitudinal_v20160229
https://wiki.mozilla.org/api.php?action=query&list=backlinks&bltitle=Telemetry/LongitudinalExamples
 
That table has a row for each client, with columns for the different parts of the ping.
Some properties are directly available to query on:
SELECT count(*) AS count
FROM longitudinal_v20160229
WHERE os = 'Linux'
 
=== Arrays ===
Other properties are arrays, which contain one entry for each submission from that client (newest first):
SELECT reason[1] AS newest_reason
FROM longitudinal_v20160229
WHERE os = 'Linux'
 
Links:
* [https://prestodb.io/docs/current/functions/array.html Documentation on array functions]
 
=== 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:
* [https://prestodb.io/docs/current/functions/map.html Documentation on map functions]
 
=== Examples ===
* Blocklist URLs (extensions.blocklist.url):
SELECT bl, COUNT(bl)
FROM
  (SELECT 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 element_at(settings, 1).blocklist_enabled AS bl
    FROM longitudinal_v20160229)
GROUP BY bl

Latest revision as of 22:11, 7 November 2016

This document is now hosted here: https://github.com/mozilla/telemetry-batch-view/blob/master/docs/longitudinal_examples.md

Wiki pages linking to this dead page: https://wiki.mozilla.org/api.php?action=query&list=backlinks&bltitle=Telemetry/LongitudinalExamples

Retrieved from "https://wiki.mozilla.org/index.php?title=Telemetry/LongitudinalExamples&oldid=1153872"