Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAMVC6ROw42WVxV9G4k2XRpciqb7D3MNs6d+GtnFJ0VsZMnppcg@mail.gmail.com>
References: 
 <CAJLYvfYUa2s-UFGq+qK4xR_rpo9tY3cSF=sTvXcPQAqzZaxEOQ@mail.gmail.com>
	<CAMVC6ROw42WVxV9G4k2XRpciqb7D3MNs6d+GtnFJ0VsZMnppcg@mail.gmail.com>
Date: Mon, 30 Nov 2015 08:47:49 +0100
Message-ID: 
 <CAJLYvfaz4EpDBiGC=KLBMGnQQ0XyR16MpfLS2HX2YuY_Xpz=Lg@mail.gmail.com>
Subject: Re: Rowkey design
From: Marko Dinic <hacker.marko@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a114d79780128c30525bd42f8

--001a114d79780128c30525bd42f8
Content-Type: text/plain; charset=UTF-8

Hi Tariq,

Thank you for your answer.

But won't that break the ordering of my rows by timestamp thus making it
impossible to scan by time range using STARTROW ENDROW?

Best regards,
Marko

On Monday, November 30, 2015, Mohammad Tariq <dontariq@gmail.com> wrote:

> Hi Marko,
>
> You could add the place(and unit as well) to your key if that's not making
> it very long. And then use RowFilter with SubstringComparator to get the
> desired rows.
>
>
> [image: http://]
> Tariq, Mohammad
> about.me/mti
> [image: http://]
> <http://about.me/mti>
>
>
> On Mon, Nov 30, 2015 at 3:49 AM, Marko Dinic <hacker.marko@gmail.com
> <javascript:;>> wrote:
>
> > Hello, everyone!
> >
> > I'm new to HBase and I need help designing rowkeys for use case that
> looks
> > like this:
> >
> > - Products are listed, where each product has a product id.
> > - Each product has a timestamp.
> > - Each product is created in certain place (e.g. city)
> > - Each product is created by some unit (e.g. factory)
> >
> > I would like to be able to scan products from a certain time period on
> one
> > hand, from a certain place, or from a certain unit.
> >
> > I read about salting to avoid hot-spotting and I understand that rows are
> > sequential by rowkey. This will allow me to scan for a certain time
> period
> > using with following rowkey:
> >
> > salt-productId-timestamp
> >
> > And I can specify the period using STARTROW, ENDROW.
> >
> > What confuses me is how to include place (and maybe unit) into key and be
> > able to select products from certain place during certain time period?
> >
> > If I limit myself to be able to scan by one of the above (time range OR
> > place) I have an idea to duplicate data to two different tables, one with
> > (salt-productId-timestamp) and other with (salt-productId-place) keys. Is
> > that recommend or not?
> >
> > So, how to construct my keys?
> >
> > I should emphasize that i need this data to be input to MAPREDUCE JOB.
> >
> > Any help is greatly appreciated.
> >
> > --
> > Best regards,
> > Marko
> >
>


-- 
Marko Dinic

--001a114d79780128c30525bd42f8--