Cassandra (14 Blogs) Become a Certified Professional

How to open CQLSH of Cassandra installed on Windows

Last updated on Oct 08,2020 34.9K 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
  • prem says:

    Hi I got following error as

    C:Program FilesDataStax Communityapache-cassandrabin>python cqlsh localhost 9042
    File “cqlsh”, line 19
    python “`dirname “$0″`/cqlsh.py” “$@”
    ^
    SyntaxError: invalid syntax

    • EdurekaSupport says:

      Hey Prem, it depends on which version of Python you are using.
      You can try changing the line:
      python “dirname “$0″/cqlsh.py” “$@”
      to
      python2 “dirname “$0″/cqlsh.py” “$@”
      We hope this solves your issues. Cheers :)

  • rajasekhar says:

    links to google drives are not working .. please let me know if you have any other paths to install python .

  • Yulia says:

    When I’m trying to run the command python cqlsh localhost 9160, then I’m getting the below error ”
    Connection error: (‘Unable to connect to any servers’, {‘127.0.0.1’: error(10061, “Tried connecting to [(‘127.0.0.1’, 9160)]. Last error: xcfxeexe4xeaxebxfexf7xe5xedxe8xe5 xedxe5 xf3xf1xf2xe0xedxeexe2xebxe5xedxee,”)})”

    Please help me out with the same.

    Thanks
    Yulia

    • EdurekaSupport says:

      Hey Yulia, thanks for checking out our blog. With regard to the error you’re facing, you need to edit cassandra.yaml on the node you are trying to connect to and set the node ip address for rpc_address and listen_address and restart Cassandra.
      rpc_address is the address on which Cassandra listens to the client calls.
      Hope this helps. Cheers!

  • divya koshatwar says:

    do we need to install java and python in the Windows of VM instance

    • EdurekaSupport says:

      Hey Divya, thanks for checking out our blog. Java and python are compulsory to be installed in windows instance. Could you please elaborate on the query so we can answer your query better? Cheers!

    • EdurekaSupport says:

      Hey Kamlesh, thanks for checking out our blog. You’re facing the error because the Java path is not set correctly. Please install the latest version: JRE 7, set JAVA_HOME to point to it, and restart the computer. Please refer to this blog for more information: https://www.edureka.co/blog/how-to-open-cqlsh-of-cassandra-installed-on-windows/. Hope this helps. Cheers!

        • EdurekaSupport says:

          Hey Sravya, thanks for checking out our blog. Try running ./cqlsh in the CASSANDRA_HOME/bin directory directly from command line.
          Try prefixing the command with “.”, ./ only works on Unix-like Operating Systems.
          Hope this helps. Cheers!

        • Dwaraganathan says:

          please use the following command

          cqlsh localhost 9160

          It will work

  • Vipul Jain says:

    When I am trying to run the command python setup.py install under (C:thrift-0.9.1), then I am getting the below error-
    “python: cant open file ‘setup.py’: [Errno 2] No such file or directory.”

    Please help me out with the same.

    Thanks
    Vipul Jain

    • EdurekaSupport says:

      Hey Vipul, thanks for checking out the blog. You may be getting the error because you are running the command from the wrong path:
      Here we have to go into the directory that you are going to “setup”.
      For example, if you are installing numpy, and you have git-cloned it, then it probably is located at ~/numpy.
      So first cd into ~/numpy, and the type the commend like “python setup.py build” there.
      Hope this helps. Cheers!

  • Shamika Mukane says:

    where is this cassandrabin folder?
    how to get it?

    • EdurekaSupport says:

      Hey Shamika, thanks for checking out the blog. By default the location will be: /usr/bin
      Hope this helps. Cheers!

  • Prasanth says:

    Thank you for the great explanation. there is bit confusion on the folder to maintain. Is that to have three folders separately for python, cassandrabin and thrift-0.9.1 on Drive “c”?

    • EdurekaSupport says:

      Yes Prasanth!! We need to maintain these 3 different folders in C Drive.

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.