You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "alex kamil (JIRA)" <ji...@apache.org> on 2014/05/02 06:01:16 UTC

[jira] [Commented] (PHOENIX-957) increment column value

    [ https://issues.apache.org/jira/browse/PHOENIX-957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13987303#comment-13987303 ] 

alex kamil commented on PHOENIX-957:
------------------------------------

do you mean https://issues.apache.org/jira/browse/PHOENIX-400 ?

> increment column value
> ----------------------
>
>                 Key: PHOENIX-957
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-957
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: alex kamil
>
> allow incrementing column value using standard update syntax:
> UPDATE table1  SET col1 = col1 + 1 WHERE col2>7;
> for now using upsert select as a workaround:
> UPSERT INTO table1 (id, col1) SELECT id, col1+1 FROM table1 WHERE col2>7;



--
This message was sent by Atlassian JIRA
(v6.2#6252)