You can use another table as a index, using a rowkey like
'{time}:{event_id}', and then scan in the range ["10:07", "10:15").On Mon, Jan 28, 2013 at 10:06 AM, Oleg Ruchovets <[email protected]>wrote: > Hi , > > I have such row data structure: > > event_id | time > ============= > event1 | 10:07 > event2 | 10:10 > event3 | 10:12 > > event4 | 10:20 > event5 | 10:23 > event6 | 10:25 > > > Numbers of records is 50-100 million. > > > Question: > > I need to find group of events starting form eventX and enters to the time > window bucket = T. > > > For example: if T=7 munutes. > Starting from event event1- {event1, event2 , event3} were detected durint > 7 minutes. > > Starting from event event2- {event2 , event3} were detected durint 7 > minutes. > > Starting from event event4 - {event4, event5 , event6} were detected during > 7 minutes. > Is there a way to model the data in hbase to get? > > Thanks > -- *Rodrigo Pereira Ribeiro* Software Developer www.jusbrasil.com.br
