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: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=wKn3FI9JO/cokhQoKcdT+MfFtJUKjCyych1lbIZ+eai5AIEfWgkabW4ZlGnsTMRj9br2wxUItseb0NU5kl+yWj6QfECUvXscSBfuseVCu3sx2FhdA2SyQwlH957erPd6IuzRYc06Wkq+8wPBWMAG4Thpy2YsqQ0z63GzFlGeKSc=;
References: <1323812604.77360.YahooMailNeo@web120805.mail.ne1.yahoo.com>
 <CB0D360A.1FC40%doug.meil@explorysmedical.com>
 <1323814574.81998.YahooMailNeo@web120801.mail.ne1.yahoo.com>
Message-ID: <1323820580.8583.YahooMailNeo@web121713.mail.ne1.yahoo.com>
Date: Tue, 13 Dec 2011 15:56:20 -0800 (PST)
From: lars hofhansl <lhofhansl@yahoo.com>
Reply-To: lars hofhansl <lhofhansl@yahoo.com>
Subject: Re: HBase- Scan with wildcard character
To: "user@hbase.apache.org" <user@hbase.apache.org>,
  Sreeram K <sreeramk86@yahoo.com>
In-Reply-To: <1323814574.81998.YahooMailNeo@web120801.mail.ne1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="-3089137-1792194709-1323820580=:8583"

---3089137-1792194709-1323820580=:8583
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

The shell lets you only do that much.=0AHBase does not support % wildcard. =
It just happens to work in your case because % has a low ascii code.=0A=0A=
=0AYou set the startRow of the scan. It does not need to exist, but the val=
ue must sort before the rows your are looking for and after all rows before=
 it.=0ASame for the stopRow. It does not need to exist, but it must sort af=
ter the rows your are looking and before all rows you do not want to see.=
=0A=0ATry setting STARTROW to "sample1" and STOPROW to "sample1\255". That =
will work as long as ascii 255 is not used in your row keys.=0A=0A-- Lars=
=0A=0A=0A=0A________________________________=0A From: Sreeram K <sreeramk86=
@yahoo.com>=0ATo: "user@hbase.apache.org" <user@hbase.apache.org>; lars hof=
hansl <lhofhansl@yahoo.com> =0ASent: Tuesday, December 13, 2011 2:16 PM=0AS=
ubject: Re: HBase- Scan with wildcard character=0A =0AThanks Doug. I am loo=
king more from HBase shell for this.=0A=0A=0A----- Original Message -----=
=0AFrom: Doug Meil <doug.meil@explorysmedical.com>=0ATo: "user@hbase.apache=
.org" <user@hbase.apache.org>; Sreeram K <sreeramk86@yahoo.com>; lars hofha=
nsl <lhofhansl@yahoo.com>=0ACc: =0ASent: Tuesday, December 13, 2011 2:01 PM=
=0ASubject: Re: HBase- Scan with wildcard character=0A=0A=0AHi there-=0A=0A=
At some point you're probably going to want to get out of the shell, take=
=0Aa look at this...=0A=0Ahttp://hbase.apache.org/book.html#scan=0A=0A=0A=
=0A=0A=0A=0AOn 12/13/11 4:43 PM, "Sreeram K" <sreeramk86@yahoo.com> wrote:=
=0A=0A>Thanks Lars. I am looking into that.=0A>=0A>Is there a way we can se=
arch all the entries starting=A0 with 565HGOUO and=0A>print all the rows?=
=0A>=0A>Example:=0A>scan 'SAMPLE_TABLE' ,{COLUMNS=0A>=3D>['sample_info:FILE=
NAME','event_info:FILENAME'],STARTROW=3D>'sample1%'}=0A>=0A>I am seeing all=
 the Rows and information after that sample1% row in the=0A>DB.=0A>if for i=
nstance I have extra1rowid after sample1%, I am able to see that=0A>also.=
=0A>=0A>I am looking for a query to print only the rows which has Rowid sta=
rting=0A>with sample1%.=0A>=0A>can you let me know if we can get a query li=
ke that on hbase shell=0A>=0A>=0A>=0A>----- Original Message -----=0A>From:=
 lars hofhansl <lhofhansl@yahoo.com>=0A>To: "user@hbase.apache.org" <user@h=
base.apache.org>; Sreeram K=0A><sreeramk86@yahoo.com>=0A>Cc: =0A>Sent: Tues=
day, December 13, 2011 11:36 AM=0A>Subject: Re: HBase- Scan with wildcard c=
haracter=0A>=0A>info:regioninfo is actually a serialized Java object (HRegi=
onInfo). What=0A>you see in the shell the result of HRegionInfo.toString(),=
 which looks=0A>like a =0A>=0A>ruby object, but it is really just a string =
(see HRegionInfo.toString()).=0A>=0A>=0A>=0A>______________________________=
__=0A>From: Sreeram K <sreeramk86@yahoo.com>=0A>To: "user@hbase.apache.org"=
 <user@hbase.apache.org>; lars hofhansl=0A><lhofhansl@yahoo.com>=0A>Sent: T=
uesday, December 13, 2011 12:16 AM=0A>Subject: Re: HBase- Scan with wildcar=
d character=0A>=0A>Thanks Lars, I will look into that .=0A>=0A>one more que=
stion: on hbase shell.=0A>=0A>If I have :=0A>=A0 =A0 =A0 =A0 =A0=A0 hbase> =
scan 't1.', {COLUMNS =3D> 'info:regioninfo'}=A0 , it is=0A>printing all the=
 colums of regioninfo.=0A>=0A>=0A>can I have a condition like:if colum,info=
.regioninfo=3D2 (value) than print=0A>all the associated columns like info:=
regioninfo1, regioninfo2.=0A>=0A>=0A>=0A>----- Original Message -----=0A>Fr=
om: lars hofhansl <lhofhansl@yahoo.com>=0A>To: "user@hbase.apache.org" <use=
r@hbase.apache.org>; Sreeram K=0A><sreeramk86@yahoo.com>=0A>Cc: =0A>Sent: M=
onday, December 12, 2011 10:45 PM=0A>Subject: Re: HBase- Scan with wildcard=
 character=0A>=0A>First off, what you want is:=A0=A0 select * from table wh=
ere id like=0A>'4E1167677%'=A0=A0 in MySQL.=0A>Relational databases can typ=
ically use indexes to satisfy like "xxx%"=0A>type queries, but not "%xxx%" =
queries.=0A>=0A>HBase is really good at "xxx%" (prefix) type queries.=0A>=
=0A>Just create a scan object, set the startkey to "4E1167677", then call=
=0A>next resulting scanner until the returned key no longer start with=0A>"=
4E1167677".=0A>=0A>In your particular case (since your keys are hex numbers=
), you can even=0A>set the stopKey to "4E1167677z" (the z will sort after a=
ny valid hex=0A>digit),=0A>and the scanner will automatically stop at the l=
ast possible match.=0A>=0A>=0A>Have a look at the the Scan object and HTabl=
e.getScanner(...)=0A>=0A>=0A>-- Lars=0A>=0A>=0A>----- Original Message ----=
-=0A>From: Sreeram K <sreeramk86@yahoo.com>=0A>To: "user@hbase.apache.org" =
<user@hbase.apache.org>=0A>Cc: =0A>Sent: Monday, December 12, 2011 6:58 PM=
=0A>Subject: HBase- Scan with wildcard character=0A>=0A>Hi,=0A>=0A>I have a=
 Table defined with the 3 columns.=0A>I am looking for a query in HBase she=
ll to print all the values starting=0A>with some characters in Rowkey.=0A>=
=0A>Example:=0A>My rowids are:Coulm+Key=0A>4E11676773AC3B6E9A3FE1CCD1051B8C=
&1323736118749497=0A>colum=3Dxxxxxx:size,timestamp=3D67667767,value=3D=0A>=
=0A>4E11676773AC3B6E9A3FE1CCD1051B8C&132373611874988=0A>colum=3D11xxxxx:siz=
e,timestamp=3D67667767,value=3D=0A>=0A>4E11676773AC3B6E9A3FE1CCD1051B8C&132=
373611565656=0A>colum=3D1xxxxxx:size,timestamp=3D67667767,value=3D=0A>=0A>=
=0A>Something similar to mysql =3D> select * from table where id=3D'%4E1167=
677%'=0A>=0A>do we have any command like this in the HBase shell - Scan wit=
h wild=0A>characters?=0A>=0A>(or) should we end up using HIVE ? what are th=
e other options?=0A>=0A>Can you please let me know.=0A>=0A>-Sreeram =0A>
---3089137-1792194709-1323820580=:8583--