RE: Questions on the count and multiple index behaviour in cassandra

2022-09-29 Thread Durity, Sean R via user
Engineer – Cassandra From: Karthik K Sent: Wednesday, September 28, 2022 8:48 AM To: user@cassandra.apache.org Cc: rsesha...@altimetrik.com Subject: [EXTERNAL] Re: Questions on the count and multiple index behaviour in cassandra Hi Stéphane Alleaume, Thanks for your quick response. I have attached

Re: Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Bowen Song via user
It sounds like you are misusing/abusing Cassandra. I've noticed the following Cassandra anti-patterns in your post: 1. Large or uneven partitions All rows in a table in a single partition is definitely an anti-pattern unless you only have a very small number of rows. 2. "SELECT COUNT(*) FR

Re: Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Stéphane Alleaume
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 a écrit : > Hi, > > We have two doubts on cassandra 3.11 features: > > 1)

Questions on the count and multiple index behaviour in cassandra

2022-09-28 Thread Karthik K
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 datatyp