Re: [GENERAL] Statistics query

2013-04-10 Thread Steve Crawford
On 04/10/2013 10:31 AM, Chris Curvey wrote: On Wed, Apr 10, 2013 at 12:30 PM, Steve Crawford > wrote: I'm seeking ideas on the best way to craft the following query. I've stripped everything down to the bare essentials and simplified it below

Re: [GENERAL] Statistics query

2013-04-10 Thread Chris Curvey
On Wed, Apr 10, 2013 at 12:30 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > I'm seeking ideas on the best way to craft the following query. I've > stripped everything down to the bare essentials and simplified it below. > > Input data has a timestamp (actually an int received from

[GENERAL] Statistics query

2013-04-10 Thread Steve Crawford
I'm seeking ideas on the best way to craft the following query. I've stripped everything down to the bare essentials and simplified it below. Input data has a timestamp (actually an int received from the system in the form of a Unix epoch), a unit identifier and a status: event_time | unit_i