title: When case in sql does not support in cassandra cql
body: <p>I was using <code>mysql</code> earlier. Now for specific reason had to move to <code>cassandra</code>. Now I am facing some incompatibility issue with my <code>mysql queries</code> in <code>cassandra cql</code> . For example <code>when case</code> in <code>mysql</code> it seems does not support in <code>cql</code> . How to make this <code>sql</code> work in <code>cassandra</code> </p>
  
  <pre><code>SELECT age, sum(case when age&gt;0 and age&lt;=10 then 1 else 0 end)   as x0, 
  sum(case when age&gt;10 and age&lt;=20 then 1 else 0 end) as x1
  FROM user_table where location_id=24 
  </code></pre>
  
  <p>I am getting the following error: </p>
  
  <pre><code>SyntaxException: line 1:32 no viable alternative at input 'when' (... age, sum([case] when...)
  </code></pre>
  
  <p>Thanks in advance.</p>