Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Apache Cassandra Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
Apache Cassandra Essentials

Apache Cassandra Essentials

By : Nitin Padalia
4.5 (2)
close
close
Apache Cassandra Essentials

Apache Cassandra Essentials

4.5 (2)
By: Nitin Padalia

Overview of this book

Apache Cassandra Essentials takes you step-by-step from from the basics of installation to advanced installation options and database design techniques. It gives you all the information you need to effectively design a well distributed and high performance database. You’ll get to know about the steps that are performed by a Cassandra node when you execute a read/write query, which is essential to properly maintain of a Cassandra cluster and to debug any issues. Next, you’ll discover how to integrate a Cassandra driver in your applications and perform read/write operations. Finally, you’ll learn about the various tools provided by Cassandra for serviceability aspects such as logging, metrics, backup, and recovery.
Table of Contents (9 chapters)
close
close
8
Index

Allowing filtering


Cassandra, by default, only allows those queries which don't require any server-side filtering. Cassandra does this to avoid performance hits that might be caused due to these queries. Let's take the example of the employee table, which stores employee salary details department-wise:

CREATE TABLE employee ( emp_id text PRIMARY KEY, first_name text, last_name text, department text,  salary int )
CREATE INDEX emp_salary ON employee(salary)
CREATE INDEX emp_department ON employee(department)

Now, if you want to get the details of all the employees in the sales department with a salary of more than 100000, you might want to run a query as follows:

SELECT first_name, last_nameFROM employee WHERE department = 'sales' AND salary > 100000 //Won't be allowed by cassandra

But this query will not be allowed by Cassandra as, in this case, even if there are very few employees who match this criterion, Cassandra will have to filter each row of the sales department to check if it's greater...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Apache Cassandra Essentials
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon