On Fri, Jan 28, 2011 at 9:36 AM, manobal <[email protected]> wrote: > > 1 table will contain all the event types.. key is eventId (type of event) + > timestamp and value would be visitorId.. we want to find out all the > visitorId that has seen 4-5 specific event types in sequence.. > If your row key was timestamp and eventid was either a qualifier on the row key -- i.e. timestamp + eventid -- or eventid was a column then you could scan over the target time range (opentsdb.net does something like this).
With your current key schema, you must run a scan per event type and aggregate the results (there is not currently a means of having hbase do this for you -- which is the answer to your original question), or create a secondary index on userid. What other types of queries do you want to run against this table? If this is the only one, then I'd suggest your redo your keying schema. St.Ack
