CQL 3 and connector

I am evaluating ireport  designer 5.2.1 and connecting to cassandra 1.2.5

when I try to do a simple test query (Select * from columnfamily)  on our cassandra cluster from inside Ireport  I recieve the following error on the cassandra system log:

ERROR [Thrift:16] 2013-09-03 14:46:29,662 CustomTThreadPoolServer.java (line 217) Error occurred during processing of message.
java.lang.IllegalStateException: Cannot acces column family with composite key from CQL < 3.0.0
        at org.apache.cassandra.config.CFMetaData.getKeyName(CFMetaData.java:538)
        at org.apache.cassandra.cql.WhereClause.extractKeysFromColumns(WhereClause.java:146)
        at org.apache.cassandra.cql.SelectStatement.extractKeyAliasFromColumns(SelectStatement.java:172)
        at org.apache.cassandra.cql.QueryProcessor.processStatement(QueryProcessor.java:387)
        at org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:775)
        at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1672)
        at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:4048)
        at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:4036)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
        at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:199)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:722)
It seems like the cassandra connector defaults to cql2 where we are only using cql3 right now.  I have also tried to put in jdbc:cassandra://testingcassandra:9160/test?version=3.0.0
when I choose test it works until I actaully try to get fields to return.
cfavero's picture
Joined: Mar 12 2012 - 10:06am
Last seen: 9 years 4 months ago

1 Answer:


The Jaspersoft Cassandra connection currently only support CQL 2, however we are working on a new community connector that will support CQL3. We should be able to share more information in a week or so.





abroitman's picture
Joined: Aug 19 2013 - 12:25pm
Last seen: 8 years 10 months ago

Any update on when CQL3 driver will be available for download?

pradeepkumardev - 9 years 2 months ago