How to insert map type into cassandra using cassandra-driver for python

Question

Since, cassandra supports map type. I want to insert a python dict into cassandra. I tried this:

cql = "Insert into table_name (my_key, name, my_dict) values (%s, %s, %s)" % (my_key, name, my_dict)

session.execute(cql)

This obviously didn't work.

I already have a map type column in my column family. How do I go about it?

Error: TypeError: not all arguments converted during string formatting

Answer 1

Use parameter passing form instead of string interpolation:

cql = "Insert into table_name (my_key, name, my_dict) values (%s, %s, %s)"
session.execute(cql,  (my_key, name, my_dict))