Fill Values for Missing Data from Apache Cassandra Database

When you import data from a Cassandra^® database into MATLAB^® using the partitionRead or executecql functions, these functions convert the fill values for missing data from the Cassandra column to the corresponding MATLAB values. This table identifies the data types in a Cassandra database column (Cassandra Query Language (CQL) data type) and the corresponding fill value for missing data in the MATLAB table.

CQL Data Type	MATLAB Fill Value
`ascii`	`<missing>`
`bigint`	`0`
`blob`	`[]`
`boolean`	`false`
`counter`	`0`
`date`	`NaT`
`decimal`	`[]`
`double`	`NaN`
`float`	`NaN`
`inet`	`<missing>`
`int`	`0`
`list<type>`	`[]`
`map<keyType,valueType>`	`0x2 table` (empty table)
`set<type>`	`[]`
`smallint`	`0`
`text`	`<missing>`
`time`	`NaN`
`timestamp`	`NaT`
`timeuuid`	`<missing>`
`tinyint`	`0`
`tuple<Type1,...,TypeN>`	`1xn table`, where the missing value in each variable is the MATLAB fill value for the corresponding CQL data type
user-defined type (UDT)	`1xn table`, where the missing value in each variable is the MATLAB fill value for the corresponding CQL data type
`uuid`	`<missing>`
`varchar`	`<missing>`
`varint`	`[]`

Documentation

Fill Values for Missing Data from Apache Cassandra Database

See Also

Related Topics

External Websites

Database Toolbox Documentation

Support