Skip to Content
Mastering Apache Cassandra 3.x - Third Edition
book

Mastering Apache Cassandra 3.x - Third Edition

by Aaron Ploetz, Tejaswi Malepati
October 2018
Beginner to intermediate content levelBeginner to intermediate
348 pages
10h
English
Packt Publishing
Content preview from Mastering Apache Cassandra 3.x - Third Edition

CONSISTENCY

By default, cqlsh is set to a consistency level of ONE. But it also allows you to specify a custom consistency level, depending on what you are trying to do. These different levels can be set with the CONSISTENCY command:

CONSISTENCY LOCAL_QUORUM;SELECT last_name,first_name FROM customer ; last_name | first_name-----------+------------       Tam |      Simon Washburne |      Hoban Washburne |       Zoey(3 rows)

On a related note, queries at CONSISTENCY ALL force a read repair to occur. If you find yourself troubleshooting a consistency issue on a small to mid-sized table (fewer than 20,000 rows), you can quickly repair it by setting the consistency level to ALL and querying the affected rows.

Querying at consistency ALL and forcing a read repair comes ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Apache Cassandra - Second Edition

Mastering Apache Cassandra - Second Edition

Nishant Neeraj

Publisher Resources

ISBN: 9781789131499Supplemental Content