Virtual machine installation for Cassandra CQL query Last Updated : 29 Oct, 2019 Comments Improve Suggest changes Like Article Like Report 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. Comment More infoAdvertise with us Next Article Virtual machine installation for Cassandra CQL query A Ashish_rana Follow Improve Article Tags : DBMS Apache Similar Reads Database Roles in CQL (Cassandra Query Language) Cassandra Query Language (CQL) is the query language used to interact with Cassandra databases. Unlike traditional relational databases, Cassandra does not have a built-in concept of database roles. Instead, access control is managed at the object level, such as the keyspace, table, or column level. 5 min read Useful CQL query in Cassandra Prerequisite - Cassandra In this article, we are going to discuss CQL query which is very useful to create, insert, delete, manipulate, filtering data etc. Let's discuss how we can write the better CQL query for these operations. Cassandra Query Language (CQL): CQL is used to create, insert, manipul 3 min read Time To Live (TTL) for a column in Cassandra In this article we will discuss how to insert and update using Time To Live (TTL) command and how to determine the expire time limit of an existing column. In Cassandra Time to Live (TTL) is play an important role while if we want to set the time limit of a column and we want to automatically delete 3 min read Additional Functions in CQL (Cassandra Query Language) In this article, we will discuss several functions that are supported by CQL in Cassandra which can help in converting one value type into another new value directly by using the function. In Cassandra, there are several functions that are supported by CQL which helps in many ways such that there is 3 min read Quorum Consistency in Cassandra In this article, we will discuss how quorum consistency is helpful in Cassandra and how we can calculate it, and also discuss how quorum consistency works. What is Quorum Consistency? Quorum consistency is consistency in Cassandra for high mechanism and to ensure that how many nodes will respond whe 3 min read Like