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 mohitanchlia@gmail.com
 designates 209.85.210.182 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPQV63UJ-WnwfOmUQ-tNN6YMQE9tdBfpg9bwFFLuEnURnudZig@mail.gmail.com>
References: 
 <CAOT3TWrHOwkKAyutfm1m7pf=VxW0bcdJJNxpzh8BzP-1r0o6vw@mail.gmail.com>
	<CAAT7MkoAr7X=yt6uoBbvu_59-P-K0dy-0brWOkJPLCPK9PrbDw@mail.gmail.com>
	<CAAT7Mkqtor6vsqUy0pbg7hTi6F-AtSfbMKM14uCkXwySc7mbng@mail.gmail.com>
	<CAOT3TWo4Zgexu0cHizSLfOQLPhpxrOSRYTEZjAZc-ghxGMB91w@mail.gmail.com>
	<CAPQV63UJ-WnwfOmUQ-tNN6YMQE9tdBfpg9bwFFLuEnURnudZig@mail.gmail.com>
Date: Thu, 28 Mar 2013 08:17:58 -0700
Message-ID: 
 <CAOT3TWp5DDpJ3-nh9szypkeFacdeZZD9jpPz8sV_QD1dXUnxiA@mail.gmail.com>
Subject: Re: Understanding scan behaviour
From: Mohit Anchlia <mohitanchlia@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=14dae934049fe9b45d04d8fda822

--14dae934049fe9b45d04d8fda822
Content-Type: text/plain; charset=ISO-8859-1

My understanding is that the row key would start with +++++ for instance.

On Thu, Mar 28, 2013 at 7:53 AM, Jean-Marc Spaggiari <
jean-marc@spaggiari.org> wrote:

> Hi Mohit,
>
> I see nothing wrong with the results below. What would I have expected?
>
> JM
>
> 2013/3/28 Mohit Anchlia <mohitanchlia@gmail.com>:
>  > I am running 92.1 version and this is what happens.
> >
> >
> > hbase(main):003:0> scan 'SESSIONID_TIMELINE', {LIMIT => 1, STARTROW =>
> > 'sdw0'}
> > ROW                                                  COLUMN+CELL
> >  s\xC1\xEAR\xDF\xEA&\x89\x91\xFF\x1A^\xB6d\xF0\xEC\x
> > column=SID_T_MTX:\x00\x00Rc, timestamp=1363056261106,
> > value=PAGE\x09\x091363056252990\x09\x09/
> >  7F\xFF\xFE\xC2\xA3\x84Z\x7F
> >
> > 1 row(s) in 0.0450 seconds
> > hbase(main):004:0> scan 'SESSIONID_TIMELINE', {LIMIT => 1, STARTROW =>
> > '------'}
> > ROW                                                  COLUMN+CELL
> >  -\xA1\xAF>r\xBD\xE2L\x00\xCD*\xD7\xE8\xD6\x1Dk\x7F\
> > column=SID_T_MTX:\x00\x00hF, timestamp=1363384706714,
> > value=PAGE\x09239923973\x091363384698919\x09/
> >  xFF\xFE\xC2\x8F\xF0\xC1\xBF
> >   row(s) in 0.0500 seconds
> > hbase(main):005:0> scan 'SESSIONID_TIMELINE', {LIMIT => 1, STARTROW =>
> > '++++'}
> > ROW                                                  COLUMN+CELL
> >  +9hC\xFC\x82s\xABL3\xB3B\xC0\xF9\x87\x03\x7F\xFF\xF
> > column=SID_T_MTX:\x00\x00<2, timestamp=1364404155426,
> > value=PAGE\x09\x091364404145275\x09 \x09/
> >  E\xC2S-\x08\x1F
> > 1 row(s) in 0.0640 seconds
> > hbase(main):006:0>
> >
> >
> > On Wed, Mar 27, 2013 at 9:23 PM, ramkrishna vasudevan <
> > ramkrishna.s.vasudevan@gmail.com> wrote:
> >
> >> Same question, same time :)
> >>
> >> Regards
> >> Ram
> >>
> >> On Thu, Mar 28, 2013 at 9:53 AM, ramkrishna vasudevan <
> >> ramkrishna.s.vasudevan@gmail.com> wrote:
> >>
> >> > Could you give us some more insights on this?
> >> > So you mean when you set the row key as 'azzzaaa', though this row
> does
> >> > not exist, the scanner returns some other row?  Or it is giving you a
> row
> >> > that does not exist?
> >> >
> >> > Or you mean it is doing a full table scan?
> >> >
> >> > Which version of HBase and what type of filters are you using?
> >> > Regards
> >> > Ram
> >> >
> >> >
> >> > On Thu, Mar 28, 2013 at 9:45 AM, Mohit Anchlia <
> mohitanchlia@gmail.com
> >> >wrote:
> >> >
> >> >> I have key in the form of "hashedid + timestamp" but when I run scan
> I
> >> get
> >> >> rows for almost every value. For instance if I run scan for 'azzzaaa'
> >> that
> >> >> doesn't even exist even then I get the results.
> >> >>
> >> >> Could someone help me understand what might be going on here?
> >> >>
> >> >
> >> >
> >>
>

--14dae934049fe9b45d04d8fda822--