Virtual machine installation for Cassandra CQL query

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.

    cqlsh 

    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

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.