Let say I have 6 nodes with replication factor of 3.
Column Family: table1
Clustering key: C1, C2
Sample Data (9 rows)
COL1 | COL2 | COL3 a1 | 01 | 'Hello' a1 | 02 | 'Hi' a1 | 03 | 'Good Morning' b1 | 01 | 'Good Afternoon' b1 | 02 | 'Lunch Time' c1 | 01 | 'Night time' c1 | 02 | 'Good night' c1 | 03 | 'Bed time' c1 | 04 | 'Tired'
is there a way to make all of "a1" to stored together in one node so that the coordinator does need to go across the cluster?