You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:18:33 UTC

[jira] [Resolved] (PHOENIX-343) Increment show case.

     [ https://issues.apache.org/jira/browse/PHOENIX-343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-343.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Increment show case.
> --------------------
>
>                 Key: PHOENIX-343
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-343
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Raymond Liu
>
> this is just for anyone who is interested to check out mu tweak on UPSERT to support atomic INCREASE
> A few usage show case :
>         CREATE TABLE test_table 
> 	(row varchar not null, col_int integer, col_long bigint, col_long2 bigint
> 	CONSTRAINT pk PRIMARY KEY (row));
>         // increase on existing row.
> 	UPSERT INTO test_table(row, col_int, col_long, col_long2) VALUES('row1', 1, 1, 1);
> 	UPSERT INTO test_table(row, col_long, col_long2) INCREASE VALUES('row1', -100, 1000);
>         // increase on non existing row.
> 	UPSERT INTO test_table(row, col_long, col_long2) INCREASE VALUES('row2', 100, 1000);



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