How to write a query with a specific range and the group by clause.

I have an ecommerce site.
I basically have to get the list of pages along with its page view count over a specific period of time.

So i have to have a query with a GROUP BY of only the 'Page name' and specific date range.

Can someone please help

1 Answer

« Back to question.

Can you give some data sample? As I tried to explain in this post:http://www.couchbase.com/communities/q-and-a/how-specify-startkeywhere-k... it is something complex to do since the range query is reading the full index and we read the startkey from left to right only (as a full key)

This is one of the reason we are building a more powerfull query engine that is available as developer preview: http://query.couchbase.com/

And you can even test it online:
http://query.pub.couchbase.com/tutorial/#1
to see what could be done

Regards
Tug