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.
thoughts?
Any update on when CQL3 driver will be available for download?