Confirmed users
95
edits
Telemetry/LongitudinalExamples: Difference between revisions
Add sampling example, change page structuring
Gfritzsche (talk | contribs) (Added UNNEST example) |
Gfritzsche (talk | contribs) (Add sampling example, change page structuring) |
||
| Line 1: | Line 1: | ||
Note: There is good background in the [https://gist.github.com/vitillo/627eab7e2b3f814725d2 example notebook] for the longitudinal data set. | Note: There is good background in the [https://gist.github.com/vitillo/627eab7e2b3f814725d2 example notebook] for the longitudinal data set. | ||
=== Table structure === | |||
Get an overview of the longitudinal data table: | Get an overview of the longitudinal data table: | ||
| Line 9: | Line 11: | ||
FROM longitudinal_v20160229 | FROM longitudinal_v20160229 | ||
WHERE os = 'Linux' | WHERE os = 'Linux' | ||
=== Sampling === | |||
While composing queries, it can be helpful to work on small samples to reduce query runtimes: | |||
SELECT * FROM longitudinal LIMIT 1000 ... | |||
=== Arrays === | === Arrays === | ||