[
https://issues.apache.org/jira/browse/CASSANDRA-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14081232#comment-14081232
]
Jeremiah Jordan commented on CASSANDRA-7654:
--------------------------------------------
Since we optimize batch inserts to a single partition, I don't really see the
need to add a new funky syntax with restrictions on it to insert. Just makes
docs that much more user unfriendly.
> 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)
