title: Some type of GROUP BY with COUNT in Cassandra
body: <p>everyone.</p>
  
  <p>I'm new with Cassandra and I got a question.</p>
  
  <p>I asked for a model... <a href="https://stackoverflow.com/questions/35965182/need-to-queryng-into-a-column-or-collection-in-cassandra/36025371?noredirect=1#comment59704145_36025371">Need to queryng into a column (or collection) in Cassandra</a></p>
  
  <p>And now, I want to know if there's a way of know how many coincidences match with my query?</p>
  
  <p>In SQL, I can do something like:</p>
  
  <pre><code>SELECT id
         count(1) c
  FROM example 
  WHERE id = 1 and ((c1 = '1' and c2 = '2') or (c1 = '3' and c2 = '4'))
  GROUP BY 
  id,
  c;
  </code></pre>
  
  <p>And that's return the id and the count of coincidences of the fields.</p>
  
  <p>If c1 = '3' doesn't exist. The count is 1.</p>
  
  <p>There's a way of do this on Cassandra. I know that GROUP BY don't exist in Cassandra. But, some idea?</p>
  
  <p>Thanks a lot, mates :D</p>