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 dontariq@gmail.com designates
 209.85.128.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CANqzD4MUYZuA7Ozb6qAZWdZRQBbhSzRDf+4EuWkfNhJzSPW_2g@mail.gmail.com>
References: 
 <CANqzD4MUYZuA7Ozb6qAZWdZRQBbhSzRDf+4EuWkfNhJzSPW_2g@mail.gmail.com>
From: Mohammad Tariq <dontariq@gmail.com>
Date: Tue, 19 Feb 2013 21:46:05 +0530
Message-ID: 
 <CAMVC6RMg3M=wg=se3TQ3nspmWsZUpp=8Mwyj73qZz-r0+Aa3GQ@mail.gmail.com>
Subject: Re: Rowkey design question
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7bdc8db002196404d6162beb

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

Hello Paul,

    Try this and see if it works :
       scan.setStartRow(Bytes.toBytes(startDate.getTime() + ""));
       scan.setStopRow(Bytes.toBytes(endDate.getTime() + 1 + ""));

Also try not to use TS as the rowkey, as it may lead to RS hotspotting.
Just add a hash to your rowkeys so that data is distributed evenly on all
the RSs.

Warm Regards,
Tariq
https://mtariq.jux.com/
cloudfront.blogspot.com


On Tue, Feb 19, 2013 at 9:41 PM, Paul van Hoven <
paul.van.hoven@googlemail.com> wrote:

> Hi,
>
> I'm currently playing with hbase. The design of the rowkey seems to be
> critical.
>
> The rowkey for a certain database table of mine is:
>
> timestamp+ipaddress
>
> It looks something like this when performing a scan on the table in the
> shell:
> hbase(main):012:0> scan 'ToyDataTable'
> ROW                                         COLUMN+CELL
>  1357020000000+192.168.178.9                column=CF:SampleCol,
> timestamp=1361288601717, value=Entry_1 = 2013-01-01 07:00:00
>
> Since I got several rows for different timestamps I'd like to tell a
> scan to just a region of the table for example from 2013-01-07 to
> 2013-01-09. Previously I only had a timestamp as the rowkey and I
> could restrict the rowkey like that:
>
> SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
>                         Date startDate = formatter.parse("2013-01-07
> 07:00:00");
>                         Date endDate = formatter.parse("2013-01-10
> 07:00:00");
>
>                         HTableInterface toyDataTable =
> pool.getTable("ToyDataTable");
>                         Scan scan = new Scan( Bytes.toBytes(
> startDate.getTime() ),
> Bytes.toBytes( endDate.getTime() ) );
>
> But this no longer works with my new design.
>
> Is there a way to tell the scan object to filter the rows with respect
> to the timestamp, or do I have to use a filter object?
>

--047d7bdc8db002196404d6162beb--