Using SELECT with the Cassandra storage engine

As with the previous recipe, the SELECT statements are much the same when using the Cassandra storage engine tables.

Getting ready

First, we need to complete the Using INSERT, UPDATE, and DELETE with the Cassandra storage engine recipe.

How to do it...

1. Open the mysql command-line client and connect to our MariaDB database server and the test database.

2. Select everything from the test01_cass table using the following command:

   SELECT * FROM test01_cass;
   

3. Select ten rows from the notes_cass table using the following command:

   SELECT * FROM notes_cass LIMIT 10; 
   

4. Select data with multiple WHERE clauses, an ORDER BY clause, and a LIMIT clause using the following commands:

   SELECT * FROM notes_cass 
     WHERE note_note IS NOT NULL 
       AND note_id < 500 
       AND LENGTH(note_note) < 30 
     ORDER BY note_id DESC 
     LIMIT 10; 
   

5. Join the notes_cass table in the test database to the publishers table in the isfdb database with some WHERE clauses and a LIMIT clause...