You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Niraj Gupta <ni...@gmail.com> on 2019/10/16 07:47:56 UTC

Re: Phoenix index REBUILD stuck in BUILDING state

On Wed, Oct 16, 2019 at 12:43 PM Niraj Gupta <ni...@gmail.com> wrote:

> Hi,
> I'm trying to rebuild a secondary global index with the following command:
> ALTER INDEX <INDEX NAME> ON SCHEMA.TABLE_NAME  REBUILD;
>
> This table has 100+ GB of data and it's stuck for the last 12 hours.
> Is there any way using which I can track the progress or make it faster?
>
> --
> Regards,
> Niraj Gupta
> +91 7275338980
>


-- 
Regards,
Niraj Gupta
+91 7275338980

Re: Phoenix index REBUILD stuck in BUILDING state

Posted by Aleksandr Saraseka <as...@eztexting.com>.

Hello Niraj.
You can use ASYNC option and then rebuild index with IndexTool (map-reduce
under the hood)
https://issues.apache.org/jira/browse/PHOENIX-2890

Re: Phoenix index REBUILD stuck in BUILDING state

Posted by Aleksandr Saraseka <as...@eztexting.com>.

Hello Niraj.
You can use ASYNC option and then rebuild index with IndexTool (map-reduce
under the hood)
https://issues.apache.org/jira/browse/PHOENIX-2890