Re: Aggregates: Largest Groups

From: Gene Wirchenko <>
Date: Mon, 22 Mar 2010 14:19:26 -0700
Message-ID: <>

On Mon, 22 Mar 2010 16:12:50 -0500, (David Fetter) wrote:

>Gene Wirchenko <> wrote:
>> On Mon, 22 Mar 2010 15:42:09 -0500, (David Fetter)
>> wrote:
>>>Let's say I have a traffic monitoring system. The stream of data
>>>coming in records a timestamp and a speed for each vehicle.
>>>I'd like to know what all the groups of vehicles larger than X whose
>>>with average speed over Y is.
>>>Any ideas how to approach this?
>> First, define your terms. What is a group? What does "larger
>> than X" mean? (Size of vehicle? Number of vehicles in the group?)
>Number of vehicles in the group.

     And what is a group?


Gene Wirchenko Received on Mon Mar 22 2010 - 16:19:26 CDT

Original text of this message