hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: Understanding scan behaviour
Date Thu, 28 Mar 2013 15:26:52 GMT
Hi Mohit,

"+" ascii code is 43
"9" ascii code is 57.

So "+9" is coming after "++". If you don't have any row with the exact
key "+++++", HBase will look for the first one after this one. And in
your case, it's +9hC\xFC\x82s\xABL3\xB3B\xC0\xF9\x87\x03\x7F\xFF\xF.

JM

2013/3/28 Mohit Anchlia <mohitanchlia@gmail.com>:
> 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?
>> >> >>
>> >> >
>> >> >
>> >>
>>

Mime
View raw message