I have one requirement, where I used range query on clustered column to pull data of non primary column.
Select list of udt objects where year = 2019( partition key) and month = 11 ( partition key ) and dayhour <=3124 (clustered column)
Dayhour = clustered column.
Year = partition key
Month = partition key
List of udt objects = non primary column.
What I understand from documentation is above kind of range queries are still efficient , as it will hit only one partition and
Partition key columns also in where clause.
As per I understand, data belong to one partition will remain in single node and other nodes can be replicas. Is that correct statement?
Is it possible that with token distribution among nodes, can we have single partition data distributed among multiple nodes.(disregarding replicas).