title: how to change column type counter to bigint in cassandra?
body: <pre class="lang-sql prettyprint-override"><code>CREATE TABLE temp (
      id bigint PRIMARY KEY,
      date timestamp,
      count counter
  )
  </code></pre>
  
  <p>I have a cassandra table^ . I want to change field type counter to <code>bigint</code>. </p>
  
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE temp ALTER count TYPE counter ;
  </code></pre>
  
  <blockquote>
    <p>ConfigurationException:  ErrorMessage code=2300 [Query invalid because
    of configuration issue] message="Cannot change count from type bigint
    to type counter: types are incompatible."</p>
  </blockquote>