We have two CAS queries. It was working just fine with 2 containers per region. We have increased containers from 2 to 3 then we started seeing the WriteTimeoutException. The traffic is same or even less compared to the regular business hours. Cassandra is in 3 regions and each cluster has 3 hosts.

Is it possible to read selectively from a Apache Cassandra row? I heard that “Typically an entire row is read behind the scenes every time a read query is fired”. Is it possible to reduce pressure on the database engine by reading selective columns? By reducing pressure I’m not talking about the typical avoid select * which would translate into less IO and make the data movement across the network faster; I’m talking about internally does the DB engine pull the entire row into memory before serving the results? I’m being conscious about wide rows and would like to make my read occupy a very small foot print.