Table Features

DSE Version: 6.0


There is some other neat CQL functionality that you should be familar with before you get down to creating your data model. This includes collection data types, UDTs, counters, UDFs and UDAs.


Hello!  I’m Tanya Gallagher, and I am here to talk to you about some other cool CQL functionality that you really should know about before you begin creating your data model in earnest.

So what are we going to cover in the next few sections?  Well, first we will talk about why you want to know about the stuff we are going to talk about in the next few sections!  Then we will move onto the collection data types that Apache Cassandra offers. From here we will move into how you can create your own flexible data types using User Defined Types or for short, UDTs.  Then we will introduce counters which includes what they are, how to implement them and what to watch out for. We will round off these few sections with User Defined Functions and User Defined Aggregates, which get a little more complicated but provides flexibility on the querying side.  So why are we talking about them now? We haven’t even built the data model! However there is some stuff you have to to do your tables before you can use them. Let’s jump right in!

Okay!  So why do you care about Collections, Counters, UDTs, UDFs and UDAs?  Before you start any major project, it best to know what tools you have in your toolbox.  Knowing about these things before your build your actual data model allows you to make some design decisions early on.

Furthermore, you should care because knowing about these tools may streamline your data model.  For example, you might end up with few tables knowing that you can store collections. You might simplify your table design.

Maybe you can get away with fewer tables. In other words, knowing what these things are and how to use them could entirely change your data model.  You want to pre-optimize your data model as much as you can before you start loading it up with data.

No write up.
No Exercises.
No FAQs.
No resources.
Comments are closed.