phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Indexes
Date Thu, 30 Jan 2014 00:21:49 GMT
Hi Justin,
Please take a look at this FAQ:
http://phoenix.incubator.apache.org/faq.html#/Why_isnnullt_my_secondary_index_being_used

If that's not the case for you, can you include your CREATE TABLE, CREATE
INDEX, SELECT statement, and EXPLAIN plan?

Thanks,
James


On Wed, Jan 29, 2014 at 4:13 PM, Justin Workman <justinjworkman@gmail.com>wrote:

> I am seeing some odd behavior with indexes and want some clarification on
> how they are used.
>
> When I create an table in phoenix on top of an existing Hbase table, and
> then create an index on this table, I can see the index get built and
> populated properly, however no queries show that they are using this index
> when I run an explain on the query.
>
> However, if I create an seperete table in Phoenix and do an upsert from my
> hbase table into the new table that I created, and create the same index as
> on the previous table. Then my queries show that they would use the index
> when running them through the explain plan.
>
> Are we not able to create or use an index on a table we create over an
> exiting Hbase table, or am I doing something wrong?
>
> Thanks in advance for any help.
> Justin
>

Mime
View raw message