Inserting or updating data into a user-defined type (UDT)
How to insert or update data into a user-defined type (UDT).
If a table specifies a user-defined type (UDT) to hold data,
then either INSERT
or UPDATE
is used to enter
data.
Procedure
Inserting data into a UDT
-
Set or replace user-defined type data, using the
INSERT
orUPDATE
command, and enclosing the user-defined type with curly brackets, separating each key-value pair in the user-defined type by a colon.cqlsh> INSERT INTO cycling.cyclist_stats (id, lastname, basics) VALUES ( e7ae5cf3-d358-4d99-b900-85902fda9bb0, 'FRAME', { birthday : '1993-06-18', nationality : 'New Zealand', weight : null, height : null } );
Note: Note the inclusion of null values for UDT elements that have no value. A value, whether null or otherwise, must be included for each element of the UDT. -
Data can be inserted into a UDT that is nested in another
column type. For example, a list of
races, where the race name, date, and time are defined
in a UDT has elements enclosed in curly brackets that are
in turn enclosed in square brackets.
cqlsh> INSERT INTO cycling.cyclist_races (id, lastname, firstname, races) VALUES ( 5b6962dd-3f90-4c93-8f61-eabfa4a803e2, 'VOS', 'Marianne', [{ race_title : 'Rabobank 7-Dorpenomloop Aalburg',race_date : '2015-05-09',race_time : '02:58:33' }, { race_title : 'Ronde van Gelderland',race_date : '2015-04-19',race_time : '03:22:23' }] );
Note: The UDT nested in the list is frozen, so the entire list will be read when querying the table.