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

Posted to user@phoenix.apache.org by Kumar Palaniappan <kp...@marinsoftware.com> on 2016/02/04 21:11:15 UTC

Disable Index

While data migration, we simply drop the indices on the tables and
recreate. Would like to avoid.

Is there disable all index syntax in phoenix grammar? How do we disable an
index? If we disable index in phoenix and rebuild what does that translates
to phoenix intercepting WAL? We know rebuilding index is pretty much takes
same time as dropping/recreating the index. How does it work anyway will it
try to repair itself after enabling?

Best.
Kumar

Re: Disable Index

Posted by James Taylor <ja...@apache.org>.

See https://phoenix.apache.org/language/index.html#alter_index

On Thu, Feb 4, 2016 at 12:11 PM, Kumar Palaniappan <
kpalaniappan@marinsoftware.com> wrote:

> While data migration, we simply drop the indices on the tables and
> recreate. Would like to avoid.
>
> Is there disable all index syntax in phoenix grammar? How do we disable an
> index? If we disable index in phoenix and rebuild what does that translates
> to phoenix intercepting WAL? We know rebuilding index is pretty much takes
> same time as dropping/recreating the index. How does it work anyway will it
> try to repair itself after enabling?
>
> Best.
> Kumar
>