Postgres aggregation queries

mozilla / crashathon

2 stars 3 forks source link

Postgres aggregation queries #3

Open robhudson opened 8 years ago

robhudson commented 8 years ago

Assuming an Elasticsearch mapping with the following fields:

clientId
appVersion
creationDate
geoCountry

Compose an Elasticsearch query that will aggregate on ClientId for a given creationDate range. For extra credit we can support optional filters by appVersion or geoCountry.

Part of this will probably be to generate some fake data for testing until we have real telemetry data loaded.

washort commented 8 years ago

We decided on IRC that Postgres would be much better for this since Elasticsearch's aggregation stuff doesn't fit our problem very well.

I've committed a simple client-id/crash-count query.