Reputation: 119
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
Upvotes: 5
Views: 3294
Reputation: 369494
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))
Upvotes: 5