phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tongzhou Wang (Simon)" <>
Subject Re: Bulk loading and index
Date Sat, 25 Jun 2016 23:13:32 GMT
Hi Josh,

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 <> 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?
>> Thanks,
>> Tongzhou

View raw message