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 ...
