Does the Cassandra connector work with CQL 3?

0

At the Ubuntu prompt I do this:

$ cqlsh -3 localhost
Connected to ******** at localhost:9160.
[cqlsh 2.2.0 | Cassandra 1.1.9.8 | 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;
 count
-------
  1002
 
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: 5 years 10 months ago

1 Answer:

0

Hi,

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
378
Joined: Nov 24 2012 - 3:52pm
Last seen: 3 years 11 months ago

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

pradeepkumardev - 5 years 7 months ago
Feedback