Columnar Database

Explore data in wide column database using Database Toolbox™ Interface for Apache Cassandra® Database

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.

Functions

expand all

cassandraApache Cassandra database connection
closeClose Apache Cassandra database connection
isopenDetermine if Apache Cassandra database connection is open
columninfoRetrieve column information from Apache Cassandra database table
partitionReadImport data from partitions of Apache Cassandra database table
tablenamesList names of database tables in Apache Cassandra database
upsertInsert or update data in Apache Cassandra database
executecqlExecute CQL query on Apache Cassandra database

Topics

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.

Troubleshooting

Database Toolbox Interface for Apache Cassandra Database Error Messages

Address Database Toolbox Interface for Apache Cassandra Database error messages.