Data types in tables

The Data API supports the following data types for columns in tables:

Unsupported types, formats, and modifiers include:

The following types have limited support:

For more information, see Migrate to the Data API from CQL.

The Data API returns warnings and errors if you use an unsupported type or attempt to insert a value that doesn’t match the column’s defined type.

For example, if you attempt to insert a value that doesn’t match the column’s type, the Data API returns "INVALID_COLUMN_VALUES".

Similarly, the Data API returns an error if you attempt to perform an operation on a column that isn’t compatible with the specified operation. For example, if you attempt to filter on a vector column, the Data API returns "INVALID_FILTER_EXPRESSION".