cassandra version Error

Question

Hi anyone instruct me which version of cassandra should I use to run cqlsh-3.4.3, So that i will be able to run GROUP BY queries.

Currently My environment is

[cqlsh 5.0.1 | Cassandra 3.9 | CQL spec 3.4.2 | Native protocol v4]

Error on trying bin/cqlsh --cqlversion=3.4.3

Connection error: ('Unable to connect to any servers', {'127.0.0.1': ProtocolError("cql_version '3.4.3' is not supported by remote (w/ native protocol). Supported versions: [u'3.4.2']",)})

Please Suggest.Thanks.

Same Error while tried with cassandra 3.7 Also.

Answer 1

You can try to force cqlsh to use a specific cql version using the option

--cqlversion="#.#.#"

example: cqlsh 127.0.0.1 9042 --cqlversion="3.2.0" (in your case: 3.4.2)

example of mine:

me@XXX:~$ cqlsh <cassandra_ip>
Connection error: ('Unable to connect to any servers', {<cassandra_ip>: ProtocolError("cql_version '3.4.2' is not supported by remote (w/ native protocol). Supported versions: [u'3.3.1']",)})
me@XXX:~$ cqlsh <cassandra_ip> --cqlversion="3.3.1"
Connected to UAT Analytics Cluster at <cassandra_ip>:9042.
[cqlsh 5.0.1 | Cassandra 2.2.8 | CQL spec 3.3.1 | Native protocol v4]
Use HELP for help.
cqlsh> 

UPDATE

(1) group by will be supported in CQL 3.4.3 and Cassandra 3.10.

(2) It is not recommended to upgrade CQL spec for Cassandra of specific version. OR it is impossible to upgrade CQL spec version for one Cassandra version (here).

(3) In order to use group by, you should upgrade cassandra to 3.10, OR user defined functions, OR change your table design...