ViewQuery only returns small portion of the data

Couchbase Server
1

Hi,

I am using python sdk to retrieve data fro a view query. The view is designed to emit meta.id based on a ‘type’, the reduce function is a simple _count.

Based on the query result from the web portal, the total record count of the view is 205million. However, when using python sdk to query the view, I can only retrieve 200k records.

I tried to make change to the connection timeout value and server indexer scan timeout, but that don’t work.

Any idea or suggestion on how to get the entire data by view query?

best,
edward

2

If you’re running a query with reduce, you should pass reduce=True to bucket.query() to execute the reduce function. Can you post the code you’re running?

Also note that you can always use the query.encoded property to see how the SDK is actually sending out your query.