You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Bipin Nag <bi...@gmail.com> on 2015/09/05 05:10:34 UTC

Updating a row

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

Re: Updating a row

Posted by James Taylor <ja...@apache.org>.

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 <jd...@gmail.com> 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" <bipin.nag@gmail.com
> <javascript:_e(%7B%7D,'cvml','bipin.nag@gmail.com');>> 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
>>
>

Re: Updating a row

Posted by Jaime Solano <jd...@gmail.com>.

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" <bi...@gmail.com> 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
>