Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

ashok.dcosta_187920 avatar image
ashok.dcosta_187920 asked ·

Is doing a full table scan an anti-pattern in Cassandra?

Is doing full scan a antipattern in cassandra , what about multi-table , is that anti pattern ?

cassandra
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

smadhavan avatar image
smadhavan answered ·

@ashok.dcosta_187920, Yes, doing a full table scan is a definite anti-pattern and is not efficient for a distributed NoSQL database like Apache Cassandra™. Having said that, it might be okay to perform a scan within a partition based on circumstances. I am going to have you refer to the below resources for additional context,

Could you update your original question elaborating what do you mean by "multi-table" for additional clarity? Alternatively, you can accept this answer if you're good.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.