In the first case, the partitioning is based on key1,key2,key3. In the second case, partitioning is based on key1 , key2. Additionally you have a clustered key key3. This means within a partition you can do range queries on key3 efficiently. That is the difference.
regards On Tue, Dec 27, 2016 at 7:42 AM, Voytek Jarnot <voytek.jar...@gmail.com> wrote: > Wondering if there's a difference when querying by primary key between the > two definitions below: > > primary key ((key1, key2, key3)) > primary key ((key1, key2), key3) > > In terms of read speed/efficiency... I don't have much of a reason > otherwise to prefer one setup over the other, so would prefer the most > efficient for querying. > > Thanks. > -- http://khangaonkar.blogspot.com/
