Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of rodriguinho@jusbrasil.com.br
 designates 209.85.212.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMFcGX3jzw=ZsBf0ZAsHdkMAdFt_SJn1fv1-xrcBbwy++U9Qrg@mail.gmail.com>
References: 
 <CAMFcGX3jzw=ZsBf0ZAsHdkMAdFt_SJn1fv1-xrcBbwy++U9Qrg@mail.gmail.com>
Date: Mon, 28 Jan 2013 12:17:37 -0300
Message-ID: 
 <CAEowmH_bxh8bdNfVxDxLiY__VfNbrfHA9+epsqc_uzyjE+yviQ@mail.gmail.com>
Subject: Re: how to model data based on "time bucket"
From: Rodrigo Ribeiro <rodriguinho@jusbrasil.com.br>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=f46d043c7d14fcce1804d45ac6fe

--f46d043c7d14fcce1804d45ac6fe
Content-Type: text/plain; charset=ISO-8859-1

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 <oruchovets@gmail.com>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

--f46d043c7d14fcce1804d45ac6fe--