Thanks Lars, I will look into that .
one more question: on hbase shell.
If I have :
hbase> scan 't1.', {COLUMNS => 'info:regioninfo'} , it is printing
all the colums of regioninfo.
can I have a condition like:if colum,info.regioninfo=2 (value) than print all
the associated columns like info:regioninfo1, regioninfo2.
----- Original Message -----
From: lars hofhansl <[email protected]>
To: "[email protected]" <[email protected]>; Sreeram K
<[email protected]>
Cc:
Sent: Monday, December 12, 2011 10:45 PM
Subject: Re: HBase- Scan with wildcard character
First off, what you want is: select * from table where id like '4E1167677%'
in MySQL.
Relational databases can typically use indexes to satisfy like "xxx%" type
queries, but not "%xxx%" queries.
HBase is really good at "xxx%" (prefix) type queries.
Just create a scan object, set the startkey to "4E1167677", then call next
resulting scanner until the returned key no longer start with "4E1167677".
In your particular case (since your keys are hex numbers), you can even set the
stopKey to "4E1167677z" (the z will sort after any valid hex digit),
and the scanner will automatically stop at the last possible match.
Have a look at the the Scan object and HTable.getScanner(...)
-- Lars
----- Original Message -----
From: Sreeram K <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
Sent: Monday, December 12, 2011 6:58 PM
Subject: HBase- Scan with wildcard character
Hi,
I have a Table defined with the 3 columns.
I am looking for a query in HBase shell to print all the values starting with
some characters in Rowkey.
Example:
My rowids are:Coulm+Key
4E11676773AC3B6E9A3FE1CCD1051B8C&1323736118749497
colum=xxxxxx:size,timestamp=67667767,value=
4E11676773AC3B6E9A3FE1CCD1051B8C&132373611874988
colum=11xxxxx:size,timestamp=67667767,value=
4E11676773AC3B6E9A3FE1CCD1051B8C&132373611565656
colum=1xxxxxx:size,timestamp=67667767,value=
Something similar to mysql => select * from table where id='%4E1167677%'
do we have any command like this in the HBase shell - Scan with wild characters?
(or) should we end up using HIVE ? what are the other options?
Can you please let me know.
-Sreeram
