phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: ON DUPLICATE KEY with Global Index
Date Tue, 09 Oct 2018 20:07:57 GMT
We do not allow atomic upsert and throw the corresponding exception in the
cases documented under the limitations section of
http://phoenix.apache.org/atomic_upsert.html.  Probably a documentation
needs a little touch to convey this clearly.

On Tue, Oct 9, 2018 at 10:05 AM Josh Elser <elserj@apache.org> wrote:

> Can you elaborate on what is unclear about the documentation? This
> exception and the related documentation read as being in support of each
> other to me.
>
> On 10/9/18 5:39 AM, Batyrshin Alexander wrote:
> >   Hello all,
> > Documentations (http://phoenix.apache.org/atomic_upsert.html) say:
> >
> > "Although global indexes on columns being atomically updated are
> supported, it’s not recommended as a potentially a separate RPC across the
> wire would be made while the row is under lock to maintain the secondary
> index."
> >
> > But in practice we get:
> > CANNOT_USE_ON_DUP_KEY_WITH_GLOBAL_IDX(1224, "42Z24", "The ON DUPLICATE
> KEY clause may not be used when a table has a global index." )
> >
> > Is this bug or documentation is outdated?
> >
>

Mime
View raw message