FROZEN data type
Synopsis
Use the FROZEN data type to specify columns of binary strings that result from serializing collections, tuples, or user-defined types.
Syntax
type_specification ::= FROZEN<type>
Where
typeis a well-formed YCQL data type (additional restrictions fortypeare covered in the Semantics section below).
Semantics
- Columns of type
FROZENcan be part of thePRIMARY KEY. - Type parameters of
FROZENtype must be either collection types (LIST,MAP, orSET) or user-defined types. FROZENtypes can be parameters of collection types.- For any valid frozen type parameter
type, values oftypeare convertible intoFROZEN<type>.
Examples
ycqlsh:example> CREATE TABLE directory(file FROZEN<LIST<TEXT>> PRIMARY KEY, value BLOB);
ycqlsh:example> INSERT INTO directory(file, value) VALUES([ 'home', 'documents', 'homework.doc' ], 0x);
ycqlsh:example> INSERT INTO directory(file, value) VALUES([ 'home', 'downloads', 'textbook.pdf' ], 0x12ab21ef);
ycqlsh:example> UPDATE directory SET value = 0xab00ff WHERE file = [ 'home', 'documents', 'homework.doc' ];
ycqlsh:example> SELECT * FROM directory;
file | value
---------------------------------------+------------
['home', 'downloads', 'textbook.pdf'] | 0x12ab21ef
['home', 'documents', 'homework.doc'] | 0xab00ff