Confirmed users
95
edits
Telemetry/LongitudinalExamples: Difference between revisions
Jump to navigation
Jump to search
adding doc links for array and map functions
Gfritzsche (talk | contribs) (Kicking off the examples) |
Gfritzsche (talk | contribs) (adding doc links for array and map functions) |
||
| Line 10: | Line 10: | ||
WHERE os = 'Linux' | WHERE os = 'Linux' | ||
=== Arrays === | |||
Other properties are arrays, which contain one entry for each submission from that client (newest first): | Other properties are arrays, which contain one entry for each submission from that client (newest first): | ||
SELECT element_at(reason, 1) AS last_reason | SELECT element_at(reason, 1) AS last_reason | ||
FROM longitudinal_v20160229 | FROM longitudinal_v20160229 | ||
WHERE os = 'Linux' | WHERE os = 'Linux' | ||
Links: | |||
* [https://prestodb.io/docs/current/functions/array.html Documentation on array functions] | |||
=== Maps === | |||
Links: | |||
* [https://prestodb.io/docs/current/functions/map.html Documentation on map functions] | |||