Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> Understanding scan behaviour


Copy link to this message
-
Re: Understanding scan behaviour
Hi Mohit,

I see nothing wrong with the results below. What would I have expected?

JM

2013/3/28 Mohit Anchlia <[EMAIL PROTECTED]>:
> 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 <
> [EMAIL PROTECTED]> wrote:
>
>> Same question, same time :)
>>
>> Regards
>> Ram
>>
>> On Thu, Mar 28, 2013 at 9:53 AM, ramkrishna vasudevan <
>> [EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]
>> >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?
>> >>
>> >
>> >
>>