Does the Cassandra connector work with CQL 3?

At the Ubuntu prompt I do this:

$ cqlsh -3 localhost
Connected to ******** at localhost:9160.
[cqlsh 2.2.0 | Cassandra | CQL spec 3.0.0 | Thrift protocol 19.33.0]
Use HELP for help.
cqlsh> use healthcare_beta;
cqlsh:healthcare_beta> select count(*) from cf_bas_day_summary;
In my report I do this:
select count(*) from cf_bas_day_summary;
But the report says that count is "3".
If I remove the count() and just do "select * from cf_bas_day_summary;" then iReport's report query spins for a minute and stops with "Error:null" in the output window.
Is this a CQL 2 vs 3 problem? Any thoughts? Thanks in advance!
topherCantrell's picture
Joined: Jul 23 2013 - 6:35am
Last seen: 9 years 7 months ago

1 Answer:


sometimes when you have the option "Automatically retrieve fields" enabled it does send the query as you are modifying the syntax. That's normal. If you get null error, you can press "Read fields" again then the result will be displayed.

Now, regarding your original question, the difference between CQL2 and CQL3 are basically compound keys. Using count(*) shouldn't be a problem. It will help to know the table definition to understand more about the problem. 

rudygodoy's picture
Joined: Nov 24 2012 - 3:52pm
Last seen: 7 years 7 months ago

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

pradeepkumardev - 9 years 4 months ago