Uploaded image for project: 'Apache Cassandra'
  1. Apache Cassandra
  2. CASSANDRA-10411

Add/drop multiple columns in one ALTER TABLE statement

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 3.6
    • None

    Description

      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.

      Attachments

        1. Cassandra-10411-trunk.diff
          18 kB
          Amit Singh Chowdhery
        2. CASSANDRA-10411.v3.patch
          35 kB
          Amit Singh Chowdhery
        3. cassandra-10411.diff
          35 kB
          Amit Singh Chowdhery

        Activity

          People

            achowdhe Amit Singh Chowdhery
            bryncooke Bryn Cooke
            Amit Singh Chowdhery
            Robert Stupp
            Votes:
            5 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: