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)