Cassandra (14 Blogs) Become a Certified Professional

How to open CQLSH of Cassandra installed on Windows

Last updated on Oct 28,2020 42.8K Views


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: hrift-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:cassandrain

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….!!

Edureka - logo

Comments
26 Comments
  • STOPNONWORKINGTUTORIALSNOW says:

    Another fucking tutorial which doesn’t work!!!!!!!!!!! Broken links!!!! Failure over failure! JUST REMOVE THIS SHIT! I HAVE LOST ONE HOUR!!!!! ABSOLUTELY NOTHING WORKS. REMOVE THIS TUTORIAL FROM THE WEB.

  • kishor k says:

    Hi,

    While running C:apache-cassandra-2.1.12bin>python cqlsh localhost 9160
    i got an below error, please help to me.
    Connection error: (‘Unable to connect to any servers’, {‘localhost’: ConnectionShutdown(‘Connection is already closed’,)})

    • EdurekaSupport says:

      Hey Kishor, there might be an issue with your port number. You can try running on localhost as well, it might fix the errors. Try executing without the port number or by changing the port number to 9042.
      Hope this helps :)

Join the discussion

Browse Categories

webinar REGISTER FOR FREE WEBINAR
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP

Subscribe to our Newsletter, and get personalized recommendations.

image not found!
image not found!

How to open CQLSH of Cassandra installed on Windows

edureka.co