Approximate row count

2016-07-27 Thread Luke Jolly
I have a table that I'm storing ad impression data in with every row being an impression. I want to get a count of total rows / impressions. I know that there is in the ball park of 200-400 million rows in this table and from my reading "Number of keys" in the output of cfstats should be a reason

Re: Approximate row count

2016-07-27 Thread Chris Lohfink
the number of keys are the number of *partition keys, *not row keys. You have ~39434 partitions, ranging from 311 bytes to 386mb. Looks like you have some wide partitions that contain many of your rows. Chris Lohfink On Wed, Jul 27, 2016 at 1:44 PM, Luke Jolly wrote: > I have a table that I'm s

Re: Approximate row count

2016-07-27 Thread Luke Jolly
Is there any other way to get an estimate of rows? On Wed, Jul 27, 2016 at 2:49 PM Chris Lohfink wrote: > the number of keys are the number of *partition keys, *not row keys. You > have ~39434 partitions, ranging from 311 bytes to 386mb. Looks like you > have some wide partitions that contain ma