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.