Database Toolbox enables you to connect to an Apache Cassandra® database, which is a wide column database, using the Database Toolbox Interface for Apache Cassandra Database. 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.
To use the Database Toolbox Interface for Apache Cassandra Database, you must first install it.
Database Toolbox Interface for Apache Cassandra Database Installation
Install the Database Toolbox Interface for Apache Cassandra Database and learn about the supported Cassandra database versions.
Explore and Import Data from Cassandra Database Table
Access the structure of a Cassandra database and import data from the database using a keyspace, database table, and partition key value.
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.
Export MATLAB Data into Cassandra Database
Export data from a MATLAB table into a Cassandra database.
Fill Values for Missing Data from Apache Cassandra Database
Convert missing values in a Cassandra database column to MATLAB values when importing data using the executecql
or
partitionRead
functions.
Convert CQL Data Types to MATLAB Data Types
View the conversion of data types between Cassandra and MATLAB for data import and export.
Database Toolbox Interface for Apache Cassandra Database Error Messages
Address Database Toolbox Interface for Apache Cassandra Database error messages.