phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Shen <wills...@marinsoftware.com>
Subject Re: How to support UPSERT with WHERE clause
Date Mon, 16 Jul 2018 17:10:07 GMT
I believe you can try using UPSERT/SELECT on the same table (without a temp
table).
Maybe you can elaborate a little bit what you are trying to do, because
your example query doesnt totally make sense to me as it is upserting
values of col 3 and 4 into 1 and 2?


On Mon, Jul 16, 2018 at 6:19 AM alchemist <alchemistsrivastava@gmail.com>
wrote:

> Thaks so much for your response:  I am looking at UPSERT Grammar:
>
> https://phoenix.apache.org/language/index.html#upsert_values
>
> Looks like Phoenix does not support SET or WHERE with UPSERT.
>
> We have UPSERT/SELECT but that is selecting data from another table to
> insert into the current table.
>
>
>
>
>
> --
> Sent from: http://apache-phoenix-user-list.1124778.n5.nabble.com/
>

Mime
View raw message