I doing a query in rethink db,
r.db('main').table('log').distinct({index: 'number'}).between(r.epochTime((new Date).setHours(0, 0, 0, 0)/1000), r.epochTime((new Date).setHours(23, 59, 59, 99)/1000), {index: 'createdAt'}).count()
number
and createdAt
are two secondary indexess. Doing this will generate the error as We are not allowed to use multiple secondary indexes in single query. I've tried to create compound index using this link, but its different from my problem. Thanks in advance.