Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAPQV63W9sK18cH1W1E4GeEyFFMYB0+mnq3xQaG31w97NAgLLDg@mail.gmail.com>
References: 
 <CAF1+Vs_-JUOz+2qvOUyMeZjOvptBuye3EE9LLCGusnES-6tC4w@mail.gmail.com>
 <CAPQV63W9sK18cH1W1E4GeEyFFMYB0+mnq3xQaG31w97NAgLLDg@mail.gmail.com>
From: anil gupta <anilgupta84@gmail.com>
Date: Mon, 8 Jun 2015 21:11:45 -0700
Message-ID: 
 <CAF1+Vs8nHL3NiPSJSuUrnRp5LjiHF_xhA2Gc9BrOjbVEYjf2Rg@mail.gmail.com>
Subject: Re: HBase shell providing wrong results with startrow(with composite
 key having String and Ints)
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a113a6f74159a6305180df6c4

--001a113a6f74159a6305180df6c4
Content-Type: text/plain; charset=UTF-8

Hi Jean,

My bad. I gave a wrong illustration. This is the query is was trying on my
composite key:
hbase(main):017:0> scan 'CAR_ARCHIVE' , {COLUMNS=>'A', STARTROW =>
'110\x00' , LIMIT=>1}
ROW
COLUMN+CELL

 12\x0010123\x0019XFB2F56CE026679\x00\x80\x00\x00\x0 column=A:BODYSTYLE,
timestamp=1432899595317,
value=SEDAN

 0

 12\x0010123\x0019XFB2F56CE026679\x00\x80\x00\x00\x0
column=A:BODYSTYLESLUG, timestamp=1432899595317, value=sedan.

I do have this rowkey: 110\x0033078\x001C4AJWAG0CL260823\x00\x80\x00\x00
So, i was expecting to get that row.


Solution: scan 'CAR_ARCHIVE' , {COLUMNS=>'A', STARTROW => "110\x00" ,
LIMIT=>1}

I dont really know what's the difference between single quotes and double
quotes in startrow. Can anyone explain? Also, It would help others, if it
can be documented somewhere.

Thanks,
Anil


On Mon, Jun 8, 2015 at 4:07 PM, Jean-Marc Spaggiari <jean-marc@spaggiari.org
> wrote:

> Hi Anil,
>
> Can you please clarify what seems to be wrong for you?
>
> You asked for start row "33078". Which mean Rows starting with a "3",
> followed by a "3", a "0", etc. and the first row returned start with a "4"
> which is correct given the startrow you have specified.
>
> You seems to have a composite key. And you seems to scan without building
> the composite key. How have you created your table and what is your key
> design?
>
> JM
>
> 2015-06-08 16:56 GMT-04:00 anil gupta <anilgupta84@gmail.com>:
>
> > Hi All,
> >
> > I m having a lot of trouble dealing with HBase shell. I am running
> > following query:
> >
> > scan 'CAR_ARCHIVE' , {COLUMNS=>'A', STARTROW => '33078' , LIMIT=>1}
> >
> > ROW
> > COLUMN+CELL
> >
> >  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> > column=A:BODYSTYLE, timestamp=1430280906358, value=SPORT
> > UTILITY
> >
> >  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> > column=A:BODYSTYLESLUG, timestamp=1430280906358,
> > value=sport-utility
> >
> >  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> > column=A:CARFAXREPORTAVAILABLE, timestamp=1430280906358,
> > value=\x01
> >
> >  4\x0010135\x001C4BJWEG2CL117550\x00\x7F\xFF\xFF\xFF
> > column=A:CARTYPE, timestamp=1430280906358, value={"isLuxury": false,
> > "isTruck": false, "isSedan": false, "isCoupe": false, "isSuv": true,
> > "isConvertible": false, "isVan": false, "isWagon": false,
> > "isEasyCareQualified": true}
> >
> > I specified, startRow='33078'. Then how come this result shows up? What's
> > going over here?
> >
> > --
> > Thanks & Regards,
> > Anil Gupta
> >
>


-- 
Thanks & Regards,
Anil Gupta

--001a113a6f74159a6305180df6c4--