Group by in Cassandra, how to use it?
<p>Hi i really need help with this! </p>

<p>In the new versions of cassandra , group by function is available , however, there isn't documentation with examples of this. I would like see examples of use along with the clause where. If i had a table like the following:</p>

<pre><code>create table mytable (
column1 text,
column2 text,
column3 text,
Primary key (column1,column2,column3));
</code></pre>

<p>I could do a query like the following? :</p>

<pre><code>Select column1 From mytable Where column2=value Group By column3
</code></pre>

<p>What is the map that should be the grouping field with partition and clustering keys?</p>