Skip to content
Related Articles

Related Articles

Virtual machine installation for Cassandra CQL query

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 29 Oct, 2019

In this article we will discuss about virtual machine installation for doing exercise of Cassandra and can execute CQL query step by step. follow the step given below.

  • Step-1:
    First download and install any one of virtual machine. here we will discuss about oracle Virtual Box. Download VirtualBox

    Figure – Oracle VirtualBox

  • Step-2:
    After installing virtual box. Go to DataStax academy to download DS220 virtual machine. Here is a link to go to DataStax Academy DS220 course. DS220 Data Modeling course

    Figure – DS220 DataStax Academy page

  • Step-3:
    Login to access and download DS220 resources. If you don’t have account then create first and then login with your credential. DS220 login page

    Figure – DS220 login page

  • Step-4:
    After downloading DS220 resources you will get these files such that box-disk1.vmdk, DS220.vbox, DS220.vmx and then open DS220.vmx file open with oracle virtual box.

    Figure – DS220 resources

  • Step-5:
    After open with DS220.vmx file with oracle virtual box. you will get DS220 virtual machine added in Oracle virtual box. then finally open Virtual Box and then double click on added DS220 virtual machine. after double click it will take few minute to open Linux virtual machine. Ignore some popup on top bar menu of window.

  • Step-6:
    Finally, Linux window virtual machine will open. let’s have a look.

    Figure – Linux virtual machine with cqlsh

  • Step-7:
    Now open terminal and change directory by using the following command.

    cd /var/log/Cassandra 

    To open cqlsh shell used the following CQL query.


    Let’s have a look,

    Figure – connect to cqlsh

    Note: If you having any issue with above steps just comment your issue with description and I will try my best to resolve your issue.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!