Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of michael_segel@hotmail.com
 designates 65.55.111.92 as permitted sender)
Message-ID: <BLU0-SMTP3746B92FF1C28F01C0648268F180@phx.gbl>
References: 
 <CAMFcGX3jzw=ZsBf0ZAsHdkMAdFt_SJn1fv1-xrcBbwy++U9Qrg@mail.gmail.com>
MIME-Version: 1.0 (1.0)
In-Reply-To: 
 <CAMFcGX3jzw=ZsBf0ZAsHdkMAdFt_SJn1fv1-xrcBbwy++U9Qrg@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
CC: "user@hbase.apache.org" <user@hbase.apache.org>
From: Michel Segel <michael_segel@hotmail.com>
Subject: Re: how to model data based on "time bucket"
Date: Mon, 28 Jan 2013 09:54:08 -0600
To: "user@hbase.apache.org" <user@hbase.apache.org>

Tough one in that if your events are keyed on time alone, you will hit a hot=
 spot on write. Reads,not so much...

TSDB would be a good start ...

You may not need 'buckets' but just a time stamp  and set up a start and sto=
p key values.

Sent from a remote device. Please excuse any typos...

Mike Segel

On Jan 28, 2013, at 7:06 AM, Oleg Ruchovets <oruchovets@gmail.com> wrote:

> Hi ,
>=20
> I have such row data structure:
>=20
> event_id | time
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> event1 | 10:07
> event2 | 10:10
> event3 | 10:12
>=20
> event4 | 10:20
> event5 | 10:23
> event6 | 10:25
>=20
>=20
> Numbers of records is 50-100 million.
>=20
>=20
> Question:
>=20
> I need to find group of events starting form eventX and enters to the time=

> window bucket =3D T.
>=20
>=20
> For example: if T=3D7 munutes.
> Starting from event event1- {event1, event2 , event3} were detected durint=

> 7 minutes.
>=20
> Starting from event event2- {event2 , event3} were detected durint 7
> minutes.
>=20
> Starting from event event4 - {event4, event5 , event6} were detected durin=
g
> 7 minutes.
> Is there a way to model the data in hbase to get?
>=20
> Thanks