Published on Jul 13,2018
22.1K Views
Email Post

Before we start the CQLSH make sure that the Cassandra server installed on windows is running. If it is running fine, you will find the below image.

cassandra-cqlshimg2

To start cqlsh we need to have python installed on your machine.

Please download the Python installer according to system configuration.

Below is my system configuration.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg3

Please use the below link if your system is 32-bit version.

https://drive.google.com/file/d/0Bw3sqswQlMb4WFJndXBKNDVzSGs/edit?usp=sharing

Please use the below link if your system is 64-bit version.

https://drive.google.com/file/d/0Bw3sqswQlMb4Y2x3ak1VQXFqQkE/edit?usp=sharing

As my system is 64-bit, I have downloaded the 64-bit version of Python.

After downloading it, double click on it and click on Run.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg4

Click on Next

cassandra-cqlshimg5

How to open CQLSH of Cassandra installed on Windows

When it asks for destination folder, let it take the default folder and click on Next.

cassandra-cqlshimg6

Click next

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg7

Let it install

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg8

You will get the below image and finally click on Finish

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg9

We have successfully installed Python on Windows.

Now Let us set the path for Python.

Right click on My Computer and go to Properties.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg10

Under System variables select the Variable Path and Click on Edit

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg18

Append “;C:\Python27” to the value of path as in the below image and click on ok.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg12

Now download the Python Thrift module from the below link.

https://drive.google.com/file/d/0Bw3sqswQlMb4UHpNSHJtMVdEY1U/edit?usp=sharing

After downloading it, extract it to C Drive.

If it is extracted, you will find it in C: as in the below image.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg13

Now open the command prompt and give the below commands.

• cd C:\thrift-0.9.1

python setup.py install

cassandra-cqlshimg14

You will get the below image.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg15

Now give the below commands to start the cqlsh

• cd c:\cassandra\bin

python cqlsh localhost 9160

cassandra-cqlshimg16

We have successfully started the cqlsh of Cassandra installed on windows.

To check if it is working fine, give the command help and check.

How to open CQLSH of Cassandra installed on Windows

cassandra-cqlshimg17

If you receive the above output, then we have started the cqlsh successfully.

Congratulations! You have successfully started the CQLSH….!!

About Author
Priyanka
Published on Jul 13,2018

Share on

Browse Categories

Comments
25 Comments