How can I find out which version of Cassandra a specific DSE is running?

Question

So far, I haven't found a place on Datastax documentation website that sums this up. Can I easily check the version some other way on a server?

Arun · Accepted Answer · 2017-11-14T21:59:55.040

73

Open cqlsh and type show VERSION.

This gives all the versions of cqlsh, DSE, Cassandra etc.

admin@cqlsh> SELECT cql_version FROM system.local;

 cql_version
-------------
       3.4.0

Also, nodetool version shows the Cassandra version

edited Nov 14 '17 at 21:59

answered Feb 17 '16 at 20:19

Arun

1,692
15
24

6

That output is very easily parsed. So, instead of opening the interactive `cqlsh`, just do `cqlsh -e "show VERSION"` and pipe that where ever. – Bruno Bronosky Apr 09 '18 at 19:51
@Arun, how did you managed to get both Cassandra and DSE in cqlsh ? What kind of installation have you performed? – Elvin Nov 13 '21 at 23:25
...only if its running, not in a build pipeline for example. – mirekphd Sep 08 '22 at 17:53

score 46 · Answer 2 · answered Jan 07 '15 at 14:36

I'm not sure if there is an explicit page that shows cassandra version by DSE release, but the 'Release Notes' page of each DSE release shows the versions that are installed. For example, here are the Release Notes for 4.5 which show all versions including cassandra that are upgraded at each minor version.

One way to check against running Cassandra instances by running the following queries in cqlsh:

select peer, release_version from system.peers;
select release_version from system.local;

This first query will return all hosts and their release version except for the local node being queried. The second query will return it for the local node being queried.

Example output:

cqlsh> select peer, release_version from system.peers;

 peer      | release_version
-----------+-----------------
 127.0.0.3 |  2.1.2-SNAPSHOT
 127.0.0.1 |  2.1.2-SNAPSHOT

(2 rows)

cqlsh> select release_version from system.local;

 release_version
-----------------
 2.1.2-SNAPSHOT

(1 rows)

You can also know the version by simply opening cqlsh. You should see something like `[cqlsh 4.1.1 | Cassandra 2.0.11.83 | DSE 4.6.0 | CQL spec 3.1.1 | Thrift protocol 19.39.0]` as part of the "welcome messages" upon connecting to a node via cqlsh — PJ., Jan 08 '15 at 05:04
That's a good point, even better for getting the local version! — Andy Tolbert, Jan 08 '15 at 17:22

score 16 · Answer 3 · answered Jul 05 '15 at 08:22

16

Simply do bin/cassandra -v , it will work even if cassandra is already running. Same -v option if you are using the service version instead of the tarball.

answered Jul 05 '15 at 08:22

sam

3,441
2
33
42

Thanks, in centos6 it is like this: `/usr/sbin/cassandra -v` – Ikrom Sep 13 '18 at 04:48
In Ubuntu-20.04 it is also `/usr/sbin/cassandra -v` – ns16 Dec 09 '20 at 05:36
1

on Ubuntu 20.04, `cassandra -v` works too. – Dut A. Jan 27 '21 at 06:11

score 11 · Answer 4 · answered Jan 02 '16 at 05:01

11

This table maps DS versions to Cassandra versions: http://docs.datastax.com/en/landing_page/doc/landing_page/compatibilityDocument.html

answered Jan 02 '16 at 05:01

Scott Bale

10,649
5
33
36

1

Nice, wonder how recent that doc is since I've never seen it. It doesn't give the full version, but having Major DSE Version <-> Major C* Version is good information to have. – Andy Tolbert Jan 02 '16 at 16:39

score 2 · Answer 5 · answered Feb 26 '15 at 15:22

2

also if you are running opscenter, on the dashboard page, you can look at what version of DSE and what version of Cassandra your nodes are running

answered Feb 26 '15 at 15:22

sebamontini

360
2
10

score 2 · Answer 6 · answered Mar 08 '22 at 16:03

2

Just run select * from system.local; in Datastax studio cql section. It gives all the details. And to know compatibility with apache cassandra version, please refer this datastax documentation page here

answered Mar 08 '22 at 16:03

Amit Kumar

813
11
13

How can I find out which version of Cassandra a specific DSE is running?

6 Answers6