[GEODE-4301] Need an API for retrieving keys for OQL query resultset

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Component/s: querying, rest (dev)
• Assignee: Unassigned
• Reporter: Abhay Dandekar
• Created: 17/Jan/18 06:02
• Updated: 20/Apr/18 04:19
• Resolved: 20/Apr/18 04:19

Description

Hi All,

I was facing an issue where we are trying to retrieve data from Geode server using REST API. We are using Adhoc query API. And our OQL results is a huge dataset. Its generally returns a million rows.

In this case, the server errors out with an OOM exception.

The idea is to have an REST API to retrieve just the keys of a QOL result set. Which can be later iterated over to retrieve the complete resultset.

I searched this over the documentation, did not find it. I also searched in the latest codebase, but could not pinpoint to the code which can help me achieve this.

Do let me know, if this feature is already implemented. If yes, I can move this issue to as a documentation bug and fix it.

Thanks and Regards,

Abhay Dandekar

Issue Links

• links to: GitHub Pull Request #1311