There's pretty limited information on Cassandra's built-in secondary index facility as is, but trying to find out why the secondary index has to have low cardinality has been like finding a needle in a haystack..that is floating somewhere in the Atlantic.
Can someone explain why low cardinality is advised for the secondary index? Has this been confirmed by anyone else besides DataStax?