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 <[email protected]> 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? >
