clustering columns IN relations when a collection is selected?

[Henry M <he...@gmail.com>]

I am trying to understand the rationale for preventing IN relations when a
collection is selected. Cassandra produces this error message:
*"InvalidRequest:
code=2200 [Invalid query] message="Cannot restrict clustering columns by IN
relations when a collection is selected by the query"*

Is this something people are open to relaxing in the future? Or is there a
reason for preventing it. It seems that if the users provide a constraint
on the partitioning key then this query could be efficient. It would also
eliminate the element of surprise for new adopters.


[image: Inline image 1]

Thank you,
Henry