[jira] [Created] (CASSANDRA-7654) CQL INSERT improvement

["Robert Stupp (JIRA)" <ji...@apache.org>]

Robert Stupp created CASSANDRA-7654:
---------------------------------------

             Summary: 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)