Columnar Database
Database Toolbox™ enables you to connect to an Apache Cassandra database, which is a wide column database, using the Apache Cassandra database C++ interface. After creating a Cassandra database connection, you can explore the database structure. Import data stored in Cassandra database tables into MATLAB® from different partitions of the database tables. Execute queries using the Cassandra Query Language (CQL) and import the results into MATLAB. Also, you can export data from MATLAB into Cassandra database tables.
Objects
connection | Apache Cassandra database connection (Since R2021a) |
CassandraConnectionOptions | Apache Cassandra database connection options (Since R2021a) |
Functions
Topics
- Explore and Import Data from Cassandra Database Table
Access the structure of a Cassandra database and import data from the database with a keyspace, database table, and partition key value using the Apache Cassandra database C++ interface.
- Import Data from Cassandra Database Table Using CQL
Write a CQL query, execute the query on the Cassandra database, and import the query results into MATLAB using the Apache Cassandra database C++ interface.
- Export MATLAB Data into Cassandra Database
Export data from a MATLAB table into a Cassandra database using the Apache Cassandra database C++ interface.
- Convert CQL Data Types to MATLAB Data Types Using Apache Cassandra Database C++ Interface
View the conversion of data types between Cassandra and MATLAB for data import and export.
- Fill Values for Missing Data from Database Using Apache Cassandra Database C++ Interface
Convert missing values in a Cassandra database column to MATLAB values when importing data by using the
executecqlorpartitionReadfunction.
