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 <[email protected]
> 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 <[email protected]>:
>
> > 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
