How to set auto increament ID(integer) in cassandra like SQL?
<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>