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.
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
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
Click on Next
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.
Click next
How to open CQLSH of Cassandra installed on Windows
Let it install
How to open CQLSH of Cassandra installed on Windows
You will get the below image and finally click on Finish
How to open CQLSH of Cassandra installed on Windows
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
Under System variables select the Variable Path and Click on Edit
How to open CQLSH of Cassandra installed on Windows
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
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
Now open the command prompt and give the below commands.
• cd C: hrift-0.9.1
python setup.py install
You will get the below image.
How to open CQLSH of Cassandra installed on Windows
Now give the below commands to start the cqlsh
• cd c:cassandrain
python cqlsh localhost 9160
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
If you receive the above output, then we have started the cqlsh successfully.
Congratulations! You have successfully started the CQLSH….!!
If you wish to learn more about SQL, then check out our SQL Certification.