Partitioning Key vs Clustering Keys in Cassandra

Partitioning Key vs Clustering Keys in Cassandra | Cassandra Fundamentals

Рет қаралды 13,601

Күн бұрын

Let’s see how different partition keys and clustering keys affect the query performance of your Cassandra tables.
The way you define your Cassandra schema is very important. You should have an idea about your read and write patterns before designing the schema. This will make sure you choose the right partition and clustering keys to organize your data in disk correctly. That way, both your reads and writes can be blazing fast.
Partition key determines which partition your data ends up in. You want to keep partitions small and related data in the same partition. It’s also important to keep in mind that one query should ideally read from one partition.
Clustering key essentially determines the order of data within a partition. Think about your queries and then think about how sorting them differently will make retrieving them much quicker. For instance, if you want the most recent data in most of your queries, have a time_created field as a clustering column and order it in a descending order, so that latest timestamp data is at the top and hence easier to retrieve.
More Cassandra videos:
Cassandra Crash Course: • Cassandra Database Cra...
#cassandra #database #partitionKeys
Visit me at irtizahafiz.com
Contact me at: irtizahafiz9@gmail.com

Пікірлер: 29

@2tce 2 жыл бұрын

Best explanation for Partition keys. I have spent a lot if time trying to find this. Thanks!!

@irtizahafiz 2 жыл бұрын

So glad it helped you understand better : )

@sharatchandra9198 Жыл бұрын

Excellent and precise explanation

@astHakobyan 8 ай бұрын

very good video

@irtizahafiz 8 ай бұрын

Thanks!

@suhaskurup 6 ай бұрын

20:26 I think you meant to type simple_temperature_v3.

@olasupodaniel6774 11 ай бұрын

This happens to be the simplest Cassandra DB tutorial I've watched so far, thank you !

@irtizahafiz 11 ай бұрын

Glad it was helpful! I will start posting again soon, so please let me know what type of content interests you the most.

@imohsimon9762 Ай бұрын

nice and simple, Thanks so much

@alexandersmirnov4274 Жыл бұрын

so why they call it as cluster key and not a sort key?

@irtizahafiz 10 ай бұрын

LOL that's a good question.

@RTXXONn 5 ай бұрын

Awsome content keep going

@irtizahafiz 5 ай бұрын

Appreciate it!

@joemobes1632 2 жыл бұрын

Thanks for the explanation, very helpful.

@gregoryweb3 Жыл бұрын

Best explanation sir I am stuck on a table which is branch_by_region_country_city but then when I saw this video about compound partition key I understand how to fix my problem , really helppp sir Thanks

@irtizahafiz 11 ай бұрын

Thank you! I will start posting again soon, so please let me know what type of content interests you the most.

@thachnnguyen 2 жыл бұрын

Unorganized so wasting time unnecessarily. Doesn't explain why one may need a compound partitioning key. Doesn't explain the impact of clustering keys (i.e., in WHERE clause, although effect in ORDER BY clause is kinda implicitly mentioned).

@irtizahafiz 2 жыл бұрын

Hi! Appreciate the feedback. I thought of explaining those but the video was getting too long. I am still learning what's the best way to present the content. Thanks for your patience!