Altering a table to add a collection

Adding or changing collection columns to a table with the ALTER TABLE command.

The ALTER TABLE command can be used to add new collection columns to a table and to alter the column type of an existing column.

Procedure

  • Alter the table cycling.upcoming_calendar to add a collection map description that can store a description for each race listed.
    cqlsh> ALTER TABLE cycling.upcoming_calendar ADD description map<text,text>;
  • After updating cycling.upcoming_calendar table to insert some data, description can be displayed.
    cqlsh> UPDATE cycling.upcoming_calendar 
    SET description = description + {'Criterium du Dauphine' : "Easy race', 'Tour du Suisse' : 'Hard uphill race'} WHERE year = 2015 AND month = 6;