phpcassandrapagination

Cassandra db PHP driver, cannot page queries with both ORDER BY and a IN restriction on the partition key

I cant get results for the following query using datastax PHP driver,

select * from track where id='35209' and day in (20180314,20180315,20180316) and datetime < '2018-03-15 11:00:00' order by datetime desc limit 1;

error message : "Cannot page queries with both ORDER BY and a IN restriction on the partition key; you must either remove the ORDER BY or the IN and sort client side, or disable paging for this query"

So how can I disable paging when "executeAsync" ?

Solution

  • You can disable paging by passing calling withDefaultPageSize on Cluster.Builder object, and passing null as an argument...