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	[]