phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: monitoring status of CREATE INDEX operation
Date Fri, 12 Aug 2016 01:40:53 GMT
Hi Nathan,
If your table is large, I'd recommend creating your index asynchronously.
To do that, you'd add the ASYNC keyword to the end of your CREATE INDEX
call. In this case, the index will be built through Map Reduce in a more
resilient manner (i.e. the client going up or down won't impact it and you
have the regular retries of a MR job). On AWS, you'll need to manually
start the MR job, but at SFDC we have a CRON job that'll start it for you
automatically (this is open source too, so it'd be good to get that up and
running in AWS as well). See for

If you don't run it asynchronously, then you'll need to increase the query
timeout (i.e. phoenix.query.timeoutMs config property) to be larger than
the time it'll take to build the index. If the client goes down before the
CREATE INDEX call finished (or the query times out), then the index build
will stop (and unfortunately will need to be run again).

To monitor the index build, there are a few ways - if running through MR,
then you can monitor the MR job in the standard way. If running
synchronously, you can monitor the index table - you'll see new regions
created as splits occur, or you could query the SYSTEM.STATS table (which
gets populated as splits and compactions happen), or you could run a
count(*) query directly against the index table (though that'll put more
load on your system because it'll require a full table scan).

HTH. Thanks,

On Thu, Aug 11, 2016 at 5:51 PM, Nathan Davis <>

> Hi All,
> I executed a CREATE INDEX against a fairly large table. And I received a
> timeout error after a minute or two, which I understand is expected.
> `!tables` in sqlline shows the index is still in BUILDING state after 2
> hours, which may be accurate since it is a pretty large table and my
> cluster is just a smallish EMR throwaway.
> My question is: Is there some way to verify that the index is in fact
> still being built? Perhaps some HBase logs or the UI or some hbase shell
> command? Unfortunately I am just as new to HBase as I am to Phoenix itself.
> Thanks,
>  -nathan

View raw message