Nested tuples/UDTs

We have seen that we can use the frozen collections nested within other collections. Similarly, we can also use tuples nested within a tuple (no need to be frozen).

For example, column_name tuple <int, tuple <int, text>>.

We can also use tuples and UDTs within other generic collections such as set, list, and map albeit they have to be frozen. Suppose that we are trying to store the education history of users. We can do so by creating a set of the user-defined type "education_information". We can create the set like this:

ALTER TABLE "users" 
ADD "education_history" set<frozen<"education_information">>; 

Let's try adding some education history for the user 'alice':

UPDATE "users" 
SET "education_history" = {{ 
  "school_name": 'Big Data University', 
  "graduation_year": 2003 
},{ 
  "school_name": 'Cassandra College', 
  "graduation_year": 2005 
}} 
WHERE "username" = 'alice'; 

Upon taking a look at the field of the row for user 'alice', you will see...