NoSQL: Create your first Cassandra Column-Family (Table)

The Cassandra Column Families (Tables):

We are calling that Cassandra is a Column Stored NoSQL Database because it is vertically scalable for high flexibility and performance by adding one or more Column Families into Keyspace.

A Column Family is a collection of ordered columns and it is a container of the rows and It stores into Cassandra Keyspace and we can create multiple Column Families into a Keyspace.

A Column Familiy also called as a Table like RDBMS Table but the Column Families are not equal to tables.

The Cassandra is a schema free database because Column Families are defined, but internal columns are not defined. As per the requirement, the application and the user can add or remove the columns at any times.

Internally, Each Column Families are stored in separate files on disk. Each row has a unique key which is called Row Key.
The Cassandra has also the concept of Super Column Family which is allowing nested access by holding a different set of columns.

In the Column Family, We can set default ordering of data, we can make compressed table, we can use compact storage, we can set data expiration.

There are also different Table properties available which can be defined with the table.
For more details you can visit this documents:
DataStax Create Table:
DataStax Table Properties:
CQL Datatypes:

Small demonstration to create a first cassandra table:

Create Keyspace if not exists:

Use a Keyspace:

Create a Sample Table:
You can use COLUMNFAMILY and TABLE keywords.


Insert a Sample record:

Drop a Table:

NoSQL Cassandra Create Table

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

Be the First to Comment!

Notify of