Hi 1) how much size in Mo is your partition ? Should be less than 100 Mo (but less in fact)
2) could you plug an Elasticsearch or Solr search in front ? Kind regards Stephane Le mer. 28 sept. 2022, 13:46, Karthik K <mailidofkarthike...@gmail.com> a écrit : > Hi, > > We have two doubts on cassandra 3.11 features: > > 1) Need to get counts of row from a cassandra table. > We have 3 node clusters with Apache Cassandra 3.11 version. > > We loaded a table in cassandra with 9lakh records. We have around 91 > columns in this table. Most of the records have text as datatype. > All these 9lakh records were part of a single partition key. > > When we tried a select count(*) query with that partition key, the query > was timing out. > > However, we were able to retrieve counts through multiple calls by > fetching only > 1 lakh records in each call. The only disadvantage here is the time taken > which > is around 1minute and 3 seconds. > > Is there any other approach to get the row count faster in cassandra? Do > we need to ' > change the data modelling approach to achieve this? Suggestions are welcome > > > 2) How to data model in cassandra to support usage of multiple filters. > We may also need the count of rows for this multiple filter query. > > Thanks & Regards, > Karthikeyan >
