Join Sheeri Cabral for an in-depth discussion in this video Querying data, part of MariaDB for MySQL Users.
…Now that you have created a Maria DB table to access the Cassandra column family,…there's some important points to know about Querying Data.…You can use the Cassandra table as you want in a Select query, and…it will work as expected including JOINS.…For the best performance, try to filter on the primary key.…That is, have your PRIMARY KEY column in your where clause.…This will push down to the Cassandra column family, and…be able to use the rowkey to find the rows you need.…Your query will run much faster.…
If you're doing a full table scan resulting in…a full Cassandra column family scan, Cassandra will scan in batches.…There is a MariaDB system variable you can set called…Cassandra_rnd_batch_size that determines the number of rows read at one time.…The default is 10,000.…My SQL has a query optimazation used in a JOIN that uses an index look up.…This is called Batched Key Access.…It works by scanning parts of the table in batches.…Cassandra supports this kind of Batched Key Access,…however the support is in "no association" mode.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.