Which version of CQLSH is compatible with Cassandra 2.1.9?

Find the cqlsh.py file in the file system and change DEFAULT_PROTOCOL_VERSION to 3:

...
DEFAULT_CQLVER = '3.3.0'
DEFAULT_PROTOCOL_VERSION = 3
DEFAULT_CONNECT_TIMEOUT_SECONDS = 5
.. .

On my system (Mac OS X installed through homebrew software), the file is located at:

/usr/local/Cellar/cassandra /2.2.0/libexec/bin/cqlsh.py

It is quite strange that you cannot overwrite this variable through the command line.

You may also need to change the actual CQL version, as follows Shown:

cqlsh 127.0.0.1 --cqlversion=3.2.0

Temporarily fix a super annoying problem..

The problem I am facing is populate_io_cache_on_flush is not a column defined in this metadata problem mentioned in the question.

According to 0700 in the second comment of the answer The specified solution, I need

“Use and service The same client library as the server. That is, after ubuntu updates the server (what happened today), all client programs must also upgrade the driver.”

I am using Cassandra 2.1.9. and cqlsh 5.0. 1.

[cqlsh 5.0.1 | Cassandra 2.1.9 | CQL spec 3.2.0 | Native protocol v3]

Which version should I use cqlsh to solve my problem?

—-

Edit (solved): I solved this problem by using the client library version 2.1.3.

My maven dependency now looks It looks like:

 com.datastax.cassandra
 cassandra-driver-core
 artifactId>
 2.1.3

Thank you for your help.

This is a super ugly but quick fix:

Find the cqlsh.py file in the file system and change DEFAULT_PROTOCOL_VERSION to 3:

...
DEFAULT_CQLVER = '3.3.0'
DEFAULT_PROTOCOL_VERSION = 3
DEFAULT_CONNECT_TIMEOUT_SECONDS = 5
...

In my system (Mac OS X installed through homebrew software), the file is located at:

/usr/local/Cellar/cassandra/2.2.0/libexec/bin/cqlsh.py 

It is quite strange that you cannot overwrite this variable through the command line.

You may also need to change the actual CQL version, as shown below:

cqlsh 127.0.0.1 --cqlversion=3.2.0

Temporarily fix a super annoying problem..