Re: 1, 2, 3...

2016-04-11 Thread Emīls Šolmanis
r 11, 2016 at 11:10 AM, <sean_r_dur...@homedepot.com> wrote: >>> >>>> Cassandra is not good for table scan type queries (which count(*) >>>> typically is). While there are some attempts to do that (as noted below), >>>> this is a path I avoid. >&g

Re: 1, 2, 3...

2016-04-11 Thread Jack Krupansky
le there are some attempts to do that (as noted below), >>> this is a path I avoid. >>> >>> >>> >>> >>> >>> Sean Durity >>> >>> >>> >>> *From:* Max C [mailto:mc_cassan...@core43.com] >>>

Re: 1, 2, 3...

2016-04-11 Thread Emīls Šolmanis
ot good for table scan type queries (which count(*) >> typically is). While there are some attempts to do that (as noted below), >> this is a path I avoid. >> >> >> >> >> >> Sean Durity >> >> >> >> *From:* Max C [mailto:mc_cassan...@c

Re: 1, 2, 3...

2016-04-11 Thread Jack Krupansky
y is). While there are some attempts to do that (as noted below), > this is a path I avoid. > > > > > > Sean Durity > > > > *From:* Max C [mailto:mc_cassan...@core43.com] > *Sent:* Saturday, April 09, 2016 6:19 PM > *To:* user@cassandra.apache.org > *Subje

RE: 1, 2, 3...

2016-04-11 Thread SEAN_R_DURITY
Subject: Re: 1, 2, 3... Looks like this guy (Brian Hess) wrote a script to split the token range and run count(*) on each subrange: https://github.com/brianmhess/cassandra-count - Max On Apr 8, 2016, at 10:56 pm, Jeff Jirsa <jeff.ji...@crowdstrike.com<mailto:jeff.ji...@crowdstrike.com&g

Re: 1, 2, 3...

2016-04-09 Thread Max C
Looks like this guy (Brian Hess) wrote a script to split the token range and run count(*) on each subrange: https://github.com/brianmhess/cassandra-count - Max > On Apr 8, 2016, at 10:56 pm, Jeff Jirsa wrote: > >

Re: 1, 2, 3...

2016-04-08 Thread Jeff Jirsa
quot; Date: Friday, April 8, 2016 at 3:48 PM To: "user@cassandra.apache.org" Subject: 1, 2, 3... I'm afraid I don't have the solid answer to this obvious question: How do I get a fairly accurate count of (CQL) rows in a Cassandra table? Does SELECT COUNT (*) FROM actually do it?

1, 2, 3...

2016-04-08 Thread Jack Krupansky
I'm afraid I don't have the solid answer to this obvious question: How do I get a fairly accurate count of (CQL) rows in a Cassandra table? Does SELECT COUNT (*) FROM actually do it? Does it really count (CQL) rows across all nodes and exclude replicated rows? Is there a better/preferred