Join Sheeri Cabral for an in-depth discussion in this video Creating a table, part of MariaDB for MySQL Users.
…When creating a maria dv table that corresponds to…a cassandra column family there are four types of columns to map.…A static column is one that appears in every row.…And is defined in Cassandra's column family header.…A dynamic column is flexible.…Each row can define its own columns.…Cassandra's super columns are not supported by MariaDB.…A rowkey is what it sounds like, it identifies the row.…
Static columns.…Our matte to regular Maria D.B. fields.…The Maria D.B. fields must have the same name as the Cassandra static columns.…If a Cassandra static column is named user name, the corresponding Maria D.B.…field must also be named user name.…Static columns must also have a similar data type in Maria D.B.…As they do in Cassandra.…Some of the data types correspond exactly, like boolean, float, double, and int.…Other Cassandra data types have an exact match, but…it is also acceptable to use other data types.…
Some data types have a one to one correspondence for the different name.…For example, varint and decimal both correspond to VARBINARY.…
- 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?
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.