CODEWITHSUNDEEP
pythoncassandra
extraDarker
extraDarker

Reputation: 119

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

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

Answers (1)

falsetru
falsetru

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

Related Questions