Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of yuzhihong@gmail.com designates
 209.85.160.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAF1+Vs8nHL3NiPSJSuUrnRp5LjiHF_xhA2Gc9BrOjbVEYjf2Rg@mail.gmail.com>
References: 
 <CAF1+Vs_-JUOz+2qvOUyMeZjOvptBuye3EE9LLCGusnES-6tC4w@mail.gmail.com>
	<CAPQV63W9sK18cH1W1E4GeEyFFMYB0+mnq3xQaG31w97NAgLLDg@mail.gmail.com>
	<CAF1+Vs8nHL3NiPSJSuUrnRp5LjiHF_xhA2Gc9BrOjbVEYjf2Rg@mail.gmail.com>
Date: Mon, 8 Jun 2015 21:23:24 -0700
Message-ID: 
 <CALte62y-HMVRt36QhnG+=R8GYAq9WGhkZpcO5hBsnwjr0UJ6yA@mail.gmail.com>
Subject: Re: HBase shell providing wrong results with startrow(with composite
 key having String and Ints)
From: Ted Yu <yuzhihong@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a1139f386888a1805180e1efa

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

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
>

--001a1139f386888a1805180e1efa--