当我使用cassandra -jdbc将数据惰性化到表中时我得到错误java.sql.SQLSyntaxErrorException：无法将'ani'解析为十六进制字节
在localhost：9160连接到测试群集 . [cqlsh 2.3.0 | Cassandra 1.2.0 | CQL规范3.0.0 | Thrift协议19.35.0]使用CQL3创建表
cqlsh:testkeyspace> create columnfamily login(
... key varchar primary key,
... name varchar,
... password varchar);
package com.bsmart;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class InsertCass {
public static void main(String[] args) {
try
{
Class.forName("org.apache.cassandra.cql.jdbc.CassandraDriver");
Connection con =DriverManager.getConnection("jdbc:cassandra://localhost:9160/testkeyspace");
String qry = "INSERT INTO login (KEY, name, password) VALUES ( 't', 'ani','agrawal');";
PreparedStatement smt = con.prepareStatement(qry);
smt.execute();
// int i=smt.executeUpdate();
System.out.println("records inserted>>>>");
}
catch(Exception e)
{
System.out.println(" error: "+e.getMessage());
e.printStackTrace();
}
}
但是错误 -
log4j:WARN No appenders could be found for logger (org.apache.cassandra.cql.jdbc.CassandraDriver).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
java.sql.SQLSyntaxErrorException: cannot parse 'ani' as hex bytes
at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.doExecute(CassandraPreparedStatement.java:155)
at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.execute(CassandraPreparedStatement.java:191)
at com.bsmart.InsertCass.main(InsertCass.java:18)
error: cannot parse 'ani' as hex bytes
请帮我 . 谢谢
2 回答
您需要将
name列创建为text或varchar. 您收到的错误表明它被创建为blob.我自己有这个问题，但在我的情况下，这是一种
double.在python的情况下，请确保指定适当的cql版本
cql.connect(cluster_address, port, keyspace, cql_version='3.1.1')