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

["Aleksey Yeschenko (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aleksey Yeschenko resolved CASSANDRA-7654.
------------------------------------------

    Resolution: Not a Problem

Resolving as Not A Problem for now, as there is a (recommended) way to get the same behavior (also pretty sure there is a duplicate issue, somewhere, resolved with Later).

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