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
`CassandraConnectionOptions`	Apache Cassandra database connection options

Functions

expand all

Configure Cassandra Data Source

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

Cassandra Database Connection

`apacheCassandra`	Create Apache Cassandra database connection
`close`	Close Apache Cassandra database connection
`isopen`	Determine if Apache Cassandra database connection is open

Import Cassandra Database Data into MATLAB

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

Export MATLAB Data into Cassandra Database

upsert Insert or update data in Apache Cassandra database

Execute CQL Query

executecql Execute CQL query on Apache Cassandra database

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.