我不熟悉apachecassandra(使用python3),我正在尝试基于csv文件创建一个表。以下是文件的外观:
https://i.stack.imgur.com/aYRS1.jpg(抱歉,我没有足够的信誉点数在这里发布图片)
首先创建表query1 = "CREATE TABLE IF NOT EXISTS table1(artist text, title text, \
length text, sessionId text, itemInSession text, PRIMARY KEY (sessionId, title, artist))"
session.execute(query1)
然后我尝试读取文件并将所需数据插入表中:
^{pr2}$
但是,我得到以下错误:---> 13 session.execute(query, (line[0], line[9], line[5], line[8], line[3]))
/opt/conda/lib/python3.6/site-packages/cassandra/cluster.cpython-36m-x86_64-linux-gnu.so in cassandra.cluster.Session.execute (cassandra/cluster.c:38536)()
/opt/conda/lib/python3.6/site-packages/cassandra/cluster.cpython-36m-x86_64-linux-gnu.so in cassandra.cluster.ResponseFuture.result (cassandra/cluster.c:80834)()
InvalidRequest: Error from server: code=2200 [Invalid query] message="Invalid STRING constant (288.9922) for "length" of type float"
即使我尝试将“length”的格式改为float,INSERT语句中的%s改为%f,也没有奏效。有人知道可能是什么问题吗?非常感谢!:)