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
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
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