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 <alchemistsrivast...@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/ >
