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

score 5 · Accepted Answer · edited Aug 19 '21 at 05:57

5

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))

edited Aug 19 '21 at 05:57

You're awesome

answered Oct 04 '14 at 09:28

falsetru

Same error:"not all arguments converted during string formatting" – extraDarker Oct 04 '14 at 09:35
@extraDarker, Could you update your question with the error message (full traceback if possible). – falsetru Oct 04 '14 at 09:35
I take my comment back, Worked! – extraDarker Oct 04 '14 at 09:54

1 Answers1