I found out that cassandra batches IN clause queries in 10s, so although the database supports up to 100 elements in IN clauses, the response will paginate if there are more than 10.
IN