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 amansk@gmail.com designates
 209.85.213.182 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CA+9AD=Ca0QGNkK1is8gyEM0WNE4v2LLOcWoyjr8PgOVAoAYnwQ@mail.gmail.com>
References: 
 <CA+9AD=AdvXa7aNx4HNFJkB8UT2ndO7-sx6t1VzZfTkYCNsmTwA@mail.gmail.com>
 <CAEfu1eMAzrGaqTWkcxXRwk9t=ikiLPBbPr+e-amOhZoVv-AxxQ@mail.gmail.com>
 <CA+9AD=Ca0QGNkK1is8gyEM0WNE4v2LLOcWoyjr8PgOVAoAYnwQ@mail.gmail.com>
From: Amandeep Khurana <amansk@gmail.com>
Date: Wed, 1 Jul 2015 12:46:15 -0700
Message-ID: 
 <CAEfu1eN8g2XD7zz1bBuwxnU8HKcP_9nWk_fPZxHLoAyuwbVcUA@mail.gmail.com>
Subject: Re: Time series scheme design
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7bea3d22c28ce00519d59545

--047d7bea3d22c28ce00519d59545
Content-Type: text/plain; charset=UTF-8

For that, I think you'll have to create a separate table with the reverse
relationship.

On Wed, Jul 1, 2015 at 12:07 PM, Sleiman Jneidi <jneidi.sleiman@gmail.com>
wrote:

> Hi Amandeep, thanks for that . I've read it already as well as your book.
> But I believe that it doesn't discuss the "feed" problem , ie: get latest
> posts from the 2k people I follow. That's for me is the challenge. I would
> really appreciate any ideas.
> Thank you.
> On Wed, 1 Jul 2015 at 7:57 pm Amandeep Khurana <amansk@gmail.com> wrote:
>
> > Hi Sleiman
> >
> > Take a look at this for some ideas:
> >
> >
> http://0b4af6cdc2f0c5998459-c0245c5c937c5dedcca3f1764ecc9b2f.r43.cf2.rackcdn.com/9353-login1210_khurana.pdf
> >
> > -Amandeep
> >
> > On Wed, Jul 1, 2015 at 11:53 AM, Sleiman Jneidi <
> jneidi.sleiman@gmail.com>
> > wrote:
> >
> > > Hello everyone, I am working on a scheme design for a time series
> > database.
> > > Something very similar to Twitter where people can follow each other
> and
> > > see their posts. I've looked at opentsdb but I think my problem is more
> > > complicated because I don't have the leading "metricid" in the row key.
> > > I've made several attempts so far but I am not happy with the
> > performance.
> > >
> > > 1. Md5(user)+timestamp . The problem with is when I want to query the
> > feed,
> > > I have to do a scan with the highest user ( alphabetical order) and the
> > > lowest and then add column column filter. Getting the next batch is
> hard.
> > >
> > > 2. Md5(user)+day and then put the posts of the day in the columns with
> > > timestamp in the qualifier name. Not optimal, getting the next batch is
> > > hard.
> > >
> > > So... What do you guys think? Any ideas for making this efficient or
> > > possible?
> > >
> > > Thanks for your time in reading this.
> > > Sleiman
> > >
> >
>

--047d7bea3d22c28ce00519d59545--