问题描述
我不确定是否更好，性能方面，使用一个非常共享的列值（如国家）作为复合主键的分区键或相当唯一的列值（如 Last_Name ）。
查看。对于辅助索引，确实有不好的是有非常独特的值，然而对于主键中的组件，这取决于我们正在关注的组件。在主键中，我们有以下组件：
分区键用于跨不同节点分布数据，如果您希望节点平衡（即跨每个节点分布良好的数据）希望您的分区键尽可能随机。这就是为什么你使用UUID的例子。
聚类键用于排序，以便查询具有特定聚类键的列可以更高效。
对正在发生的情况有很好的解释。
I'm undecided whether it's better, performance-wise, to use a very commonly shared column value (like Country) as partition key for a compound primary key or a rather unique column value (like Last_Name).
Looking at Cassandra 1.2's documentation about indexes I get this:
Looking at the examples from CQL's SELECT for
"Querying compound primary keys and sorting results", I see something like a UUID being used as partition key... which would indicate that it's preferable to use something rather unique?
Indexing in the documentation you wrote up refers to secondary indexes. In cassandra there is a difference between the primary and secondary indexes. For a secondary index it would indeed be bad to have very unique values, however for the components in a primary key this depends on what component we are focusing on. In the primary key we have these components:
The partitioning key is used to distribute data across different nodes, and if you want your nodes to be balanced (i.e. well distributed data across each node) then you want your partitioning key to be as random as possible. That is why the example you have uses UUIDs.
The clustering key is used for ordering so that querying columns with a particular clustering key can be more efficient. That is where you want your values to not be unique and where there would be a performance hit if unique rows were frequent.
The cql docs have a good explanation of what is going on.
这篇关于Cassandra：选择分区键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！