Mailing-List: contact hbase-user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hbase-user@hadoop.apache.org
Received-SPF: pass (nike.apache.org: domain of sdolgy@gmail.com designates
 209.85.220.176 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:date:x-google-sender-auth:message-id:subject
         :from:to:content-type;
        b=V1MsGpTXRoRdYyFiESk1anF7Le/HLYZv0OPYL0WGAq03qqkBkGtmXVkyaLCDNl+wLr
         StKT3KyQ+CvXtwZ/HgCqTUuotFumF0/zKM89+2UUhVpMvCjSpwpDBT+SepyMVSOJXduU
         EpJ+vgcayZl3P03vtSR2dqVYm2ChJTFoVDt9M=
MIME-Version: 1.0
Sender: sdolgy@gmail.com
Date: Wed, 13 May 2009 23:51:16 +0100
Message-ID: <2e760b510905131551k5b515a0fi3c8bd6f003040ae6@mail.gmail.com>
Subject: HBase indexes
From: Sasha Dolgy <sasha.dolgy@gmail.com>
To: hbase-user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001636c5b361879a070469d30c4b

--001636c5b361879a070469d30c4b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi there,

I have the following table created, with indexes.

{NAME => 'foo', IS_ROOT => 'false', IS_META => 'false', FAMILIES => [{NAME
=> 'entry', BLOOMFILTER => 'false',
COMPRESSION => 'NONE', VERSIONS => '3', LENGTH => '2147483647', TTL => '-1',
IN_MEMORY => 'false', BLOCKCACHE
=> 'false'}], INDEXES => [ID => hostname, ID => msg, ID => char_count, ID =>
ip]}

Now this in turn will create new 'tables' in HBase:

hbase(main):033:0> list
foo-char_count
foo-hostname
foo-msg
foo-ip

hbase(main):037:0> describe 'foo-ip'
{NAME => 'foo-ip', IS_ROOT => 'false', IS_META => 'false', FAMILIES =>
[{NAME => 'entry', BLOOMFILTER => 'false
', COMPRESSION => 'NONE', VERSIONS => '3', LENGTH => '2147483647', TTL =>
'-1', IN_MEMORY => 'false', BLOCKCAC
HE => 'false'}, {NAME => '__INDEX__', BLOOMFILTER => 'false', COMPRESSION =>
'NONE', VERSIONS => '3', LENGTH =
> '2147483647', TTL => '-1', IN_MEMORY => 'false', BLOCKCACHE => 'false'}],
INDEXES => []}


Great.  So this works so far.  I then insert a few thousand rows into the
'foo' table and then run a normal scan:

Scanner search = hbaseTableName.getScanner(searchString, "", Long.MAX_VALUE,
filter);
...

This works fine, but when I try an indexed scan i receive back no results.

Does another process need to encourage the indexes to function?

Thanks in advance, and apologies if this is something simple...big learning
curve
-sd

-- 
Sasha Dolgy
sasha.dolgy@gmail.com

--001636c5b361879a070469d30c4b--