You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Robert Stupp (JIRA)" <ji...@apache.org> on 2014/07/31 15:17:39 UTC
[jira] [Updated] (CASSANDRA-7654) CQL INSERT improvement
[ https://issues.apache.org/jira/browse/CASSANDRA-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Robert Stupp updated CASSANDRA-7654:
------------------------------------
Priority: Minor (was: Major)
> CQL INSERT improvement
> ----------------------
>
> Key: CASSANDRA-7654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7654
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Robert Stupp
> Priority: Minor
>
> It would be nice to be able to add multiple rows using a single {{INSERT}}.
> Restricted to the same partition.
> For example:
> Current behaviour:
> {noformat}
> INSERT INTO comp_key (key, num_val)
> VALUES ('foo', 1, 41);
> INSERT INTO comp_key (key, num_val)
> VALUES ('foo', 2, 42);
> {noformat}
> Wanted behaviour:
> {noformat}
> INSERT INTO comp_key (key, num_val)
> VALUES
> ('foo', 1, 41),
> ('foo', 2, 42),
> ('foo', 3, 42),
> ('foo', 4, 42);
> {noformat}
> Assumed table def:
> {noformat}
> CREATE TABLE comp_key (
> key TEXT,
> clust INT,
> num_val DECIMAL,
> PRIMARY KEY ( key, clust )
> );
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)