cqlsh:ks> // UDT can be created as part of keyspace cqlsh:ks> create type mark ( ... math text, ... science text ... ); cqlsh:ks> cqlsh:ks> // UDT can be utilized by using the 'frozen' keyword #74 cqlsh:ks> // Note : The concept of 'frozen' is given for forward cqlsh:ks> // compatibility cqlsh:ks> create table student( ... name text, ... class text, ... subjects frozen<mark>, ... primary key(name)); cqlsh:ks> cqlsh:ks> insert into student(name, class, subjects) values('bob', '3rd', ... {math: '70', science: '80'}); cqlsh:ks> select * from student; name | class | subjects ------+-------+----------------------------- bob | 3rd | {math: '70', science: '80'} (1 rows)
How to create user defined data type (UDT)....
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment