Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: softfail (athena.apache.org: transitioning domain of
 shahab.yunus@gmail.com does not designate 54.191.145.13 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <loom.20150422T130208-654@post.gmane.org>
References: <loom.20150422T130208-654@post.gmane.org>
Date: Wed, 22 Apr 2015 07:39:47 -0400
Message-ID: 
 <CAEo-6+RsUVKvMMuCRACM77pMy=6ksy8bx4q8oHSMAzkSrUQFfQ@mail.gmail.com>
Subject: Re: scan startrow and stoprow
From: Shahab Yunus <shahab.yunus@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=047d7b3a821ac3241405144e9ef6

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

I see that you are already using partial key scan approach.

When you say that you want data from the timeStamp2 as well, you want all
the rows from timeStamp2? Also, how are you actually setting the stopRow?
What are you providing for the *anyNumber field when you are setting
stopRow?

e.g. if your data is:

aabb|timeStamp1
aabb|timeStamp1|5
aabb|timeStamp1|9
aabb|timeStamp2|3
aabb|timeStamp2|4
aabb|timeStamp2|5

In this case you want all 6 rows, right?


Regards,
Shahab

On Wed, Apr 22, 2015 at 7:03 AM, Sachin <scorpio.king.yo@gmail.com> wrote:

> My rowkey format is uniqueid|timestamp|randomnumber.
>
> I want to retrieve data from hbase by using scanner with java api where my
> startRow : aabb|timeStamp1|
> stopRow is : aabb|timeStamp2|any_number
>
> timeStamp1 and timeStamp2 are time ranges. So I want to fetch all values in
> between above timestamp where my *any_number can be anything it's * in
> regular expression. So my start and stop rows become :
>
> startRow : aabb|timeStamp1|
> stopRow is : aabb|timeStamp2|*
>
> I set these param to scan object but its not fetching data from hbase. Can
> anyone tell me how to do that?
>
>

--047d7b3a821ac3241405144e9ef6--