phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yuhao Bi <>
Subject Re: Phoenix-issue with secondary index
Date Mon, 12 Oct 2015 07:56:02 GMT
Hi there,

We may have encountered the same situation.
In our environment, after creating index on a table, we cannot apply the
index in query too.
Restart HBase and wait for a long time, it still don't work.

Finally, we found that, the index status in system table is building,  so
we manually modified the index status.
And it work.
You can use ALTER INDEX to change the index status to USABLE to check your
query result.
If you got your index work, you can change it to REBUILD to make sure there
is nothing corrupted.

Please see

Yuhao Bi

2015-10-07 2:42 GMT+08:00 Gaurav Agarwal <>:

> Hello
> We create the table thorugh hbase admin
> We inserted the data through phoenix map reduce.
> We apply secondary indexes there on the table after inserting data.
> but when we do Select * from "Table", it didnot apply indexes there.
> Any idea
> why

View raw message