Columnar Database

Explore data in wide column database using Apache^® Cassandra^® database C++ interface

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

expand all

Configure Cassandra Data Source

`setoptions`	Set Apache Cassandra database connection options (Since R2021a)
`testConnection`	Test Apache Cassandra database connection (Since R2021a)
`reset`	Reset Apache Cassandra database connection options to defaults (Since R2021a)
`saveAsDataSource`	Save Apache Cassandra data source (Since R2021a)

Cassandra Database Connection

`apacheCassandra`	Create Apache Cassandra database connection (Since R2021a)
`close`	Close Apache Cassandra database connection (Since R2021a)
`isopen`	Determine if Apache Cassandra database connection is open (Since R2021a)

Import Cassandra Database Data into MATLAB

`columninfo`	Retrieve column information from Apache Cassandra database table (Since R2021a)
`partitionRead`	Import data from partitions of Apache Cassandra database table (Since R2021a)
`tablenames`	List names of database tables in Apache Cassandra database (Since R2021a)

Export MATLAB Data into Cassandra Database

upsert Insert or update data in Apache Cassandra database (Since R2021a)

Execute CQL Query

executecql Execute CQL query on Apache Cassandra database (Since R2021a)

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 executecql or partitionRead function.