Does the Cassandra connector work with CQL 3?
Posted on July 29, 2013 at 7:55am
At the Ubuntu prompt I do this:
$ cqlsh -3 localhost
Connected to ******** at localhost:9160.
[cqlsh 2.2.0 | Cassandra 220.127.116.11 | 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!
Posted on August 17, 2013 at 7:28am
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.