Join Sheeri Cabral for an in-depth discussion in this video Creating a table, part of Understanding MariaDB for MySQL Users.
- View Offline
…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