Hi,
Ran into RPC timeout exception when execution a query that involve
secondary index of a Boolean column when for example the company has more
than 1k person.
select * from company where company_id=xxxx and isMale = true;
such extreme low cardinality of secondary index like the other docs
stated, will result in basically 2 large row those values. However, I
thought since I also bounded the query with my primary partition key, won't
that be first consulted and then further narrow down the result and be
efficient?
Also, if I simply do
select * from company where company_id=xxxx ;
(without the AND clause on secondary index, it return right away)
Or mayb Cassandra server internal always parsing the secondary index result
first?
thanks
I have a simple table
create table company {
company_id uuid,
person_id uuid,
isMale Boolean,
PRIMARY KEY (company_id, person_id)
)
