CREATE INDEX async_index ON my_schema.my_table (v) ASYNC
First, thanks for the response.
As far as I can tell, a disabled index cannot be directly changed to USABLE. It must be rebuilt first. I am aware that I can do ALTER INDEX .... REBUILD. But, if I understand correctly, this is single thread and slow. I'm wondering if I can use the IndexTool map reduce job in this case.
About TTL, I did some experiments. Turns out that Phoenix do not automatically remove index entry when the table entry dies from TTL setting. However, it is possible to set index table with same TTL so that index can be in sync.
> On Jun 25, 2016, at 15:31, Josh Elser <firstname.lastname@example.org> wrote:
> Hi Tongzhou,
> Maybe you can try `ALTER INDEX index ON table DISABLE`. And then the same command with USABLE after you update the index. Are you attempting to do this incrementally? Like, a bulk load of data then a bulk load of index data, repeat?
> Regarding the TTL, I assume so, but I'm not certain.
> Tongzhou Wang wrote:
>> Hi all,
>> I am writing to ask if there is a way to disable an index, then update
>> it through the MapReduce job (IndexTool). I want to bulk load a huge
>> amount of data, but index maintaining makes it very slow. It would be
>> great if I can disable an index, load data, then use a MapReduce job to
>> update it to usable state.
>> Also, does Phoenix's secondary index maintaining take TTL into account?