CQL Datatypes in Cassandra

The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Linear implacability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra's support for replicating across multiple data centers is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.

CQL provides a rich set of built-in data types, including collection types. Along with these data types, users can also create their own custom data types.

Inclined to build a profession as Cassandra Developer? Then here is the blog post on, explore Cassandra Training

The following table provides a list of built-in data types available in CQL.

Data Types

Data Type	Constants	Description
ASCII	strings	Represents ASCII character string
bigint	bigint	Represents 64-bit signed long
blob	blobs	Represents arbitrary bytes
Boolean	booleans	Represents true or false
counter	integers	Represents counter column
decimal	integers, floats	Represents variable-precision decimal
double	integers	Represents 64-bit IEEE-754 floating-point
float	integers, floats	Represents 32-bit IEEE-754 floating-point
inet	strings	Represents an IP address, IPv4 or IPv6
int	integers	Represents 32-bit signed int
text	strings	Represents UTF8 encoded string
timestamp	integers, strings	Represents a timestamp
timeuuid	uuids	Represents type 1 UUID
uuid	uuids	Represents type 1 or type 4
		UUID
varchar	strings	Represents uTF8 encoded string
varint	integers	Represents arbitrary-precision integer

Cassandra Interview Questions

Collection Types

Cassandra Query Language also provides a collection of data types. The following table provides a list of Collections available in CQL.

Collection	Description
list	A list is a collection of one or more ordered elements.
map	A map is a collection of key-value pairs.
set	A set is a collection of one or more elements.

User-defined data types:

Cqlsh provides users a facility of creating their own data types. Given below are the commands used while dealing with user-defined datatypes.

For in-depth knowledge on Cassandra, click on below

• Cassandra NoSQL
• How To Install Cassandra Ubuntu 14.04
• Cassandra Architecture
• Cassandra Data Types
• CQL Collections in Cassandra