hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: HBase shell providing wrong results with startrow(with composite key having String and Ints)
Date Tue, 09 Jun 2015 04:23:24 GMT
Double quotes allow you to do string interpolation.
Aother difference (one pertinent to Anil's question) is that 'escape
sequence' does not work using single quote.

Cheers

On Mon, Jun 8, 2015 at 9:11 PM, anil gupta <anilgupta84@gmail.com> wrote:

> 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message