Database ToolboxInterface forApache CassandraDatabase

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

Database Toolbox enables you to connect to an Apache™ Cassandra^®database, which is a wide column database, using theDatabase 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 theDatabase Toolbox Interface for Apache Cassandra Database, you must first install it.

Functions

expand all

CassandraDatabase Connection

`cassandra`	ApacheCassandradatabase connection
`close`	Close ApacheCassandradatabase connection
`isopen`	Determine if ApacheCassandradatabase connection is open

进口CassandraDatabase Data intoMATLAB

`columninfo`	Retrieve column information from ApacheCassandradatabase table
`partitionRead`	进口data from partitions of ApacheCassandradatabase table
`tablenames`	List names of database tables in ApacheCassandradatabase

ExportMATLABData intoCassandraDatabase

upsert Insert or update data in ApacheCassandradatabase

Execute CQL Query

executecql Execute CQL query on ApacheCassandradatabase

Topics

Database Toolbox Interface for Apache Cassandra Database Installation
Install theDatabase Toolbox Interface for Apache Cassandra Databaseand 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.
进口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 theexecutecqlorpartitionReadfunctions.
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

地址Database Toolbox Interface for Apache Cassandra Databaseerror messages.