[
https://issues.apache.org/jira/browse/CASSANDRA-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14080830#comment-14080830
]
T Jake Luciani commented on CASSANDRA-7654:
-------------------------------------------
You can already accomplish this using a prepared statement, which should be the
only way we support this IMO.
http://www.datastax.com/dev/blog/client-side-improvements-in-cassandra-2-0
> CQL INSERT improvement
> ----------------------
>
> Key: CASSANDRA-7654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7654
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Robert Stupp
>
> 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)
