Confirmed users
95
edits
Telemetry/LongitudinalExamples: Difference between revisions
→Sampling: Add sampling by sample_id
No edit summary |
Gfritzsche (talk | contribs) (→Sampling: Add sampling by sample_id) |
||
| Line 17: | Line 17: | ||
SELECT * FROM longitudinal LIMIT 1000 ... | SELECT * FROM longitudinal LIMIT 1000 ... | ||
Or to look at a 1% sample of the clients: | |||
SELECT * FROM longitudinal WHERE sample_id[1] = 5 ... | |||
The sample_id partitions the clients into stable ~1% samples. | |||
=== Arrays === | === Arrays === | ||