Re: Bulk loading and index

2016-06-25 Thread Ankit Singhal
HI Tongzhou, May be you can trying dropping the current index and after your upload is completed, you can create a async index. Then you can use IndexTool to rebuild your index from start. source:- https://phoenix.apache.org/secondary_indexing.html CREATE INDEX async_index ON my_schema.my_table

Re: Bulk loading and index

2016-06-25 Thread Tongzhou Wang (Simon)
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 Ind

Re: Bulk loading and index

2016-06-25 Thread Josh Elser
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 ce

Re: phoenix on non-apache hbase

2016-06-25 Thread Benjamin Kim
What a surprise! I see that the phoenix 4.7.0-1.clabs_phoenix1.3.0.p0.000 parcel has been released by Cloudera. Now, starts the usage tests. Cheers, Ben > On Jun 9, 2016, at 10:09 PM, Ankur Jain wrote: > > I have updated my jira with updated instructions > https://issues.apache.org/jira/brows