Cassandra – Select data

In this tutorial, we will learn about the SELECT command in Cassandra which is used to retrieve the data from the cassandra table. We can perform various projections using the SELECT statement.

Syntax:

SELECT select_expression
FROM keyspace_name.table_name
WHERE relation AND relation ...
ORDER BY ( clustering_column ( ASC | DESC )...)
LIMIT n
ALLOW FILTERING

Select Expression will be given as input to the select statement, where the output depends on the select expression.

SELECT * from users;
Select count(*) from users;