phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Global Index stuck in BUILDING state
Date Wed, 11 May 2016 09:34:55 GMT
Try recreating your index with ASYNC and update index using INDEX tool so
that you don't face issues related to timeout or stuck during the initial
load of huge data.
https://phoenix.apache.org/secondary_indexing.html


On Tue, May 10, 2016 at 7:26 AM, anupama agarwal <anu1307@gmail.com> wrote:

> Hi All,
>
> I have a query, I created global index on table of 10,000,000 records. My
> global index's state is stuck at "BUILDING". I have tried running this
> query :
>
> *alter index accrual_client_ref_id_type_idx on
> apl_accrual_service.accruals USABLE; *
> which says the same.
>
> The  global index has 10k rows less than main table.  What are my options
> to fix this? Do I have to rebuild the index to fix this?
>

Mime
View raw message