Secondary index in Cassandra

Question

What are secondary index in Cassandra ?

Answer 1

Secondary indexes are indexes built over column values. In other words, let’s say you have a user table, which contains a user’s email. The primary index would be the user ID, so if you wanted to access a particular user’s email, you could look them up by their ID. However, to solve the inverse query given an email, fetch the user ID requires a secondary index.

Hope this helps!

Get your Cassandra certification today to know more and become a certified expert.

Thanks.