CQL: invalid set of literals for map type values

I have this table

create table constants_values ( key_name_1 text, key_name_2 text, values map<text, frozen<nav_tag_values>>, PRIMARY KEY(key_name_1, key_name_2) ); 

UDT:

  CREATE TYPE ks_mobApp.nav_tag_values ( values set<text> ); 

Here I insert the values:

 cqlsh:ks_mobapp> insert into constants_values(key_name_1,key_name_2,values) values('Sell', 'Electronics', {{'Mobile', {values:{'Laptop'}}}}); 

and here is the error:

 InvalidRequest: code=2200 [Invalid query] message="Invalid set literal for values of type map<text, nav_tag_values>" 

What am I missing?

+5
source share
2 answers

Try this with cqlsh :

 INSERT INTO constants_values(key_name_1,key_name_2,values) VALUES('Sell', 'Electronics', {'Mobile': {value : ['Laptop']}); 
+3
source
 INSERT INTO constants_values(key_name_1,key_name_2,values) values('Sell', 'Electronics', {'Mobile': {values:{'Laptop'}}}); 

the key point is: vs the, in your original statement.

+1
source

Source: https://habr.com/ru/post/1240798/


All Articles