cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amit Singh Chowdhery (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-10411) Add/drop multiple columns in one ALTER TABLE statement
Date Wed, 30 Dec 2015 13:23:49 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-10411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15074966#comment-15074966
] 

Amit Singh Chowdhery edited comment on CASSANDRA-10411 at 12/30/15 1:22 PM:
----------------------------------------------------------------------------

In this patch , multiple columns addition and deletion has been entertained. New syntax for
Addition will be :

Alter table tablename add ( col1 datatype <static>,col2 datatype.......coln datatype
 <static>);

New Syntax for deletion will be :

Alter table tablename drop (col1,col2,col3.....col n);

One can add single add and drop in same way which was earlier supported like :

Alter table tablename drop col1;
Alter table tablename add col1 datatype <static>;

Currently attached patch is for branch 2.0.x , In case you find any issues in auto merging
the change on 2.1,2.2 or 3 , please let me know , i will submit separate patches for that.


was (Author: achowdhe):
In this patch , multiple columns addition and deletion has been entertained. New syntax for
Addition will be :

Alter table tablename add ( col1 datatype <static>,col2 datatype.......coln datatype
 <static>);

New Syntax for deletion will be :

Alter table tablename drop (col1,col2,col3.....col n);

One can add single add and drop in same way which was earlier supported like :

Alter table tablename drop col1;
Alter table tablename add col1 datatype <static>;

Currently attached patch is for branch 2.0.x , In case to support for higher branches , please
let me know i will upload that patch also.

> Add/drop multiple columns in one ALTER TABLE statement
> ------------------------------------------------------
>
>                 Key: CASSANDRA-10411
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10411
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Bryn Cooke
>            Assignee: Amit Singh Chowdhery
>            Priority: Minor
>              Labels: patch
>             Fix For: 2.0.17
>
>         Attachments: cassandra-10411.diff
>
>
> Currently it is only possible to add one column at a time in an alter table statement.
It would be great if we could add multiple columns at a time.
> The primary reason for this is that adding each column individually seems to take a significant
amount of time (at least on my development machine), I know all the columns I want to add,
but don't know them until after the initial table is created.
> As a secondary consideration it brings CQL slightly closer to SQL where most databases
can handle adding multiple columns in one statement.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message