phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Indexes
Date Thu, 30 Jan 2014 00:21:49 GMT
Hi Justin,
Please take a look at this FAQ:

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


On Wed, Jan 29, 2014 at 4:13 PM, Justin Workman <>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

View raw message