I have a table that uses LCS and has wound up with partitions upwards of 700 MB. I am seeing lots of the large partition warnings. Client requests are subsequently failing. The driver is not reporting timeout exception, just NoHostAvailableExceptions (in the logs I have reviewed so far). I know that I need to redesign the table to avoid such large partitions. What specifically goes wrong that results in the instability I am seeing? Or put another way, what issues will compacting really large partitions cause? Initially I thought that there was high GC activity, but after closer inspection that does not really seem to happening. And most of the failures I am seeing are on reads, but for an entirely different table. Lastly, does anyone has anyone had success to switching to STCS in this situation as a work around?
Thanks - John
