http://www.datastax.com/support-forums/topic/row-count-for-a-given-column-family Software, Support, and Training for Apache Cassandra en-US Sat, 25 May 2013 17:39:52 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/row-count-for-a-given-column-family#post-2367 Mon, 25 Jun 2012 17:27:28 +0000 thobbs 2367@http://www.datastax.com/support-forums/ <p>Right, cfstats only returns values for the node you're connecting to with nodetool. Assuming your ring is balanced, you can get an estimate of the total number of rows by multiplying that number by (<code>number_of_nodes</code>/<code>RF</code>). If the ring is not balanced, you'll need to sum the results for all nodes and then divide by <code>RF</code>. </p> http://www.datastax.com/support-forums/topic/row-count-for-a-given-column-family#post-2360 Mon, 25 Jun 2012 16:25:08 +0000 ryoudelman 2360@http://www.datastax.com/support-forums/ <p>Thanks for the tips. One follow up question - does cfstats only return the values for the node you are running on? If so, is there a way to get the results for the whole ring? </p> http://www.datastax.com/support-forums/topic/row-count-for-a-given-column-family#post-2333 Fri, 22 Jun 2012 16:47:00 +0000 thobbs 2333@http://www.datastax.com/support-forums/ <p>If you just need a close approximation, nodetool cfstats will show an estimate that's within 128 of the actual count. If you need to get an exact number or need to do this programmatically and you can't use JMX, you can use <code></code>get_range()<code></code> with a column count of zero to get all of the keys. However, note that this is subject to the "range ghosts" problem: <a href="http://wiki.apache.org/cassandra/FAQ#range_ghosts" rel="nofollow">http://wiki.apache.org/cassandra/FAQ#range_ghosts</a> </p> http://www.datastax.com/support-forums/topic/row-count-for-a-given-column-family#post-2319 Fri, 22 Jun 2012 12:56:36 +0000 Anonymous 2319@http://www.datastax.com/support-forums/ <p>What is the best way to get a row count for a given column family? I am running Cassandra 1.0.8.</p> <p>Thanks. </p>