title: How to set auto increament ID(integer) in cassandra like SQL?
body: <p>I have millions of records and now I have to fetch the last latest records. I want to save each record with record_id, and I want this record_id to auto increment when a new record gets inserted.</p>
  
  <p>FOR EXAMPLE: Suppose I have 1000 record and first I want the latest 100 records from 901 to 1000.  Now on the second request, I want the next 100 latest record from 801 to 900. I have gone through so many links but have not found anything relevant.  Can any body give a proper solution?</p>
  
  <p>Let's suppose table emp contains:<br>
  name text,<br>
  record_id int,<br> 
  address text<br></p>
  
  <p>Let's assume name is primary key and record_id is cluster key.  But please don't discuss primary key concept now because my requirement is to create id as a cluster key (I'm using cassandra 2.2.3 and cql 3.3.1).  </p>