如何使用cassandra驱动程序将地图类型插入cassandra

问题描述：

因为，cassandra支持地图类型.我想在cassandra中插入一个python dict.我试过了:

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)

这显然行不通.

我的列族中已经有一个地图类型列.我该怎么办?

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

错误:TypeError:不是所有在格式化字符串期间转换的参数

Error: TypeError: not all arguments converted during string formatting

答

使用

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