Re: LOCAL vs TRANSACTIONAL indexes

2016-09-23 Thread Matthew Van Wely
> if you're ok with the overhead, that's the simplest solution from the users > POV. > > Thanks, > James > > [1] https://phoenix.apache.org/secondary_indexing.html# > Consistency_Guarantees > > On Thu, Sep 22, 2016 at 10:53 AM, Matthew Van Wely < > mv

LOCAL vs TRANSACTIONAL indexes

2016-09-16 Thread Matthew Van Wely
All, I would like some guidance on LOCAL vs TRANSACTIONAL indexes and I cannot quite get the details I need from the Phoenix site: https://phoenix.apache.org/secondary_indexing.htm Transactional Tables transactional tables with secondary indexes potentially lowers your availability of being

Re: LOCAL vs TRANSACTIONAL indexes

2016-09-22 Thread Matthew Van Wely
against various write failure scenarios. > > Thanks, > James > > On Tue, Sep 20, 2016 at 10:30 PM, Matthew Van Wely < > mvanw...@salesforce.com> wrote: > >> Thanks James, knowing that there are no race conditions (or very >> unlikely) from the same client on a m

Re: LOCAL vs TRANSACTIONAL indexes

2016-09-20 Thread Matthew Van Wely
Thanks James, knowing that there are no race conditions (or very unlikely) from the same client on a mutable table is really helpful. Thx, --Matt On Sat, Sep 17, 2016 at 4:26 PM, James Taylor <jamestay...@apache.org> wrote: > On Fri, Sep 16, 2016 at 7:22 PM, Matthew Van We