Managing columns

All data types found in CQL may be included when creating a table column. Examples of these data types in CREATE TABLE statements are useful if you choose to use a particular data type.

A counter column is a column that can contain integer values, and whose primitive operations are increment and decrement. Collections are useful for storing a grouping of data within a single column. Sets, lists, and maps are the defined collection data types. Tuples are similar to collections as a data type that allows grouping data within a single column, but are more open-ended in format.

Date and time data types are common, especially for storing time series data. UUIDs are a common data type for uniquely identifying a column value that avoids collision with other values.

A variety of common numerical data types are available.

Static columns allow you to insert a single value that can be included in multiple rows. Geospatial data types are useful for storing information that is geometric in nature, such as mapping information. Blobs can represent a constant hexadecimal number in a column.

User-defined types, or UDTs, are the ultimate in free-form data types, allowing a user to compile an unique grouping of values that will provide specific results upon querying.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000,