Do you see anything in the logs?
-----Original Message-----
From: Sasha Dolgy [mailto:[email protected]]
Sent: Wednesday, May 13, 2009 4:07 PM
To: [email protected]
Subject: Re: HBase indexes
Hi John,
tableName is the name of the table the indexes were created from - foo
ip is the index ...
HTableDescriptor desc = new HTableDescriptor(tableName);
IndexedTable table = new IndexedTable(getConfig(), desc.getName());
Scanner scanner =
table.getIndexedScanner("ip",HConstants.EMPTY_START_ROW,
null, null, null);
Basically, following some other threads I went to see how it all works
by
looking at the TestIndexedTable test case and implemented it pretty much
as
is.
-sd
On Thu, May 14, 2009 at 12:02 AM, John Ellis (MELBOURNE-AU) <
[email protected]> wrote:
> Hi -
>
> This is kinda silly, but you are using
IndexedTable.getIndexedScanner(...)?
>
> /john
>
>
> On 14/05/09 8:51 AM, "Sasha Dolgy" <[email protected]> wrote:
>
> 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
> [email protected]
>
