This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

Columnar Database

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

Database Toolbox enables you to connect to an Apache Cassandra® 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. You can also execute queries using the Cassandra Query Language (CQL) and import the results into MATLAB.

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
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.

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

For data import into MATLAB, view the conversion of data types between Cassandra and MATLAB.

Troubleshooting

Database Toolbox Interface for Apache Cassandra Database Error Messages

Address Database Toolbox Interface for Apache Cassandra Database error messages.