title: How do you update a Cassandra integer column using CQL?
body: <p>I have a table 'reviews' in Cassandra as mentioned below:</p>
  
  <pre><code>CREATE TABLE reviews (
    review_id text,
    downcount int,
    upcount int,
    creation_date timestamp,
    PRIMARY KEY (review_id)
  )
  </code></pre>
  
  <p>Lets say I want to increase the <code>upcount</code> value by 1, how can I do that in Cassandra CQL?</p>
  
  <p>When I do:</p>
  
  <pre><code>UPDATE reviews SET upcount = upcount +1 WHERE review_id = '123456';
  </code></pre>
  
  <p>It gives me the below error:</p>
  
  <blockquote>
    <p>Bad Request: Invalid operation (<code>upcount = upcount + 1</code>) for non counter column <code>upcount</code>.</p>
  </blockquote>