Insert multiple types into a map in cassandra

Question

Is it possible to enter different data types in the cassandra map, for example, if I have a table like

(id int, value map<text,text>) 

Now I want to insert values ​​into this table, for example

 (1,{'test':'test1'}) (2,{'a':1}) (3,{'c':2}) 

Answer 1

The Cassandra Map type does not support values ​​(or keys) of different types. However, you can create a Custom type to handle this.

 aploetz@cqlsh :stackoverflow2> CREATE TYPE testac (test text, a int, c int); aploetz@cqlsh :stackoverflow2> CREATE TABLE testactable ( key int, values frozen<testac>, PRIMARY KEY (key)); aploetz@cqlsh :stackoverflow2> INSERT INTO testactable (key,values) VALUES (1,{test: 'test1', a: 1, c: 2}); aploetz@cqlsh :stackoverflow2> SELECT * FROm testactable ; key | values -----+----------------------------- 1 | {test: 'test1', a: 1, c: 2} (1 rows) 

Answer 2

Instead of having a map in your case, use it as a text column (String), which will save you a lot of space. Store data in JSON format, strict it.

Answer 3

No Cassandra does not support this feature. Kassandra Map is similar to a java map, and we know that java also does not support this. we transfer all values ​​on the map according to the data type.