Main Content

Fill Values for Missing Data from Database Using Apache Cassandra Database C++ Interface

When you import data from a Cassandra® database into MATLAB® using the partitionRead or executecql functions of the Apache® Cassandra database C++ interface, 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, or CQL, data type) and the corresponding fill value for missing data in the MATLAB table.

CQL Data TypeMATLAB Fill Value

ascii

<missing>

bigint

0

blob

[]

boolean

false

counter

0

date

NaT

decimal

<missing>

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

<missing>

See Also

Objects

Functions

Related Topics

External Websites