title: Group data by daily and update in monthly and yearly table in Cassandra
body: <p>I am beginner to cassandra and have to do this..</p>
  <p>I have a table schema of daily table</p>
  <pre><code>CREATE TABLE daily(
  id text,
  date timestamp,
  total_used counter,
  PRIMARY KEY(id, date)
  )
  </code></pre>
  <p>I need to get all total_used value date-wise and then after getting those value i need to update it in month wise table (which is already there)<br />
  Table Schema for Month table</p>
  <pre><code>CREATE TABLE month(
  id text,
  year text,
  month text
  total_used counter,
  PRIMARY KEY((id,year),month)
  )
  </code></pre>
  <p>Then after updating it in monthly table i need to update same year wise in yearly table</p>
  <p>After reading alot or articles i took approach to use GROUP BY on PRIMARY KEY in daily table. But failed on how to update same in monthly and yearly table.</p>
  <p>Can anyone help me in same?</p>