Step By Step Guide to install Cassandra and Cqlsh on Windows

  Today I started to play with Cassandra by installing it in my windows machine. When I am installing Cassandra in windows I faced some issues. So I thought to share this information.

Step1: Download Cassandra from The current latest version                 is  2.0.1. It is a tar.gz file. Download and extract it in some location in your computer.
              For example you can extract D:\cassandra ..

             If you are using  cassandra 2.0.1 you must use the java1.7.If you are using cassandra                    earlier versions java1.6 is enough

Step 2: You should set the path of JAVA in SystemVariables.
              For Example Java_Home=C:\Program Files (x86)\Java\jre1.7.0
             And also set the Cassandra_Home=D:\cassandra;

Step 3:  Go to your cassandra conf folder.For example D:--->cassandra-->conf
             Change the cassandra.yaml file like fallows
               1) In the line of  #commitlog content into changed your extracting cassandra path.For                               Example as fallows
                 # commit log
                     commitlog_directory: d:/cassandra/commitlog 
and create a directory cassandra                                      named as commitlog..
             2) In the line of data_file_directories changed like fallows
                                    - d:/cassandra/data
                       and create a directory(folder) named as data...

Step 4:  You can start cassandra server by calling cassandra.bat available with in the                                         bin  directory.When server starts its shows like fallows

 Step 5: Now to interact with Cassandra database you need the cqlsh interactive command tool.              Here is the small twist. There is none in the cassandra download package. So there                    is a work around we should do before adding records to the database.

Step 5: Download python from the below location Be careful here. Though the python latest version is 3.x, there is problem with installing thrift library with the latest version of Python. So download and install 2.7 version of Python.

Step 6: Next install the PYTHON in your system.And set the path of Python in path variable.

Step 7: Now you can go to cassandra bin folder then run CQLSH.Now you connect to cassandra and create the keyspace and tables.

  • CREATE KEYSPACE mykeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; 
  • Use mykeyspace.
  • create table sample(id int primary key,name text ,desg text);



  1. can u tell how to start cassandra server

  2. This is good information. It helped me to setup the tar.gz of cassandra and cqlsh. I dont know why thrift installation instruction is not provided in apache getting started wiki page.

  3. It's really worth reading the blog post whcih has useful content. I have recently done CRS Info Solutions which is highly helpful to upgrade my career. What is the Salesforce course training fee in Chennai? Which is the best option from Salesforce training in Chennai? Who offers job oriented Salesforce training in Chennai? Find the best institute for project based Salesforce training in Chennai.

  4. You can join the free orientation at Workday training institutes in Bangalore and they located at Workday training institutes in delhi. It is highly recommendable for you to enroll at Workday training institutes in UK and you can have a great market for jobs in USA so join this wonderful Workday training institutes in USA and in India this Workday training institutes in Noida is really best institute.

  5. Myself so glad to establish your blog entry since it's actually quite instructive. If it's not too much trouble continue composing this sort of web journals and I normally visit this blog. Examine my administrations.
    Go through these Salesforce Lightning Features course. Found this Salesforce CRM Using Apex And Visualforce Training worth joining. Enroll for SalesForce CRM Integration Training Program and practice well.