To add to what Jaime said, UPSERT VALUES will update an existing row too if the row already exists.
On Saturday, September 5, 2015, Jaime Solano <[email protected]> wrote: > Hi Bipin, > You can use the UPSERT SELECT statement. > https://phoenix.apache.org/language/#upsert_select > Best, > -Jaime > On Sep 4, 2015 11:10 PM, "Bipin Nag" <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> How can I update values in an existing row. I believe the upsert >> statement does not take a where clause. How to do update ? >> >> Thanks >> Bipin >> >
