[
https://issues.apache.org/jira/browse/GEODE-4301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16332734#comment-16332734
]
Anthony Baker commented on GEODE-4301:
--------------------------------------
[[email protected]] I think you might want to consider some
alternatives. As Jason noted, you can change the OQL projection to just return
keys. Beyond that you might want to consider how to further reduce the scope
of the result set. Returning 1M entries will stress GC and network. Another
approach is to use a function and only query the local data set.
> Need an API for retrieving keys for OQL query resultset
> -------------------------------------------------------
>
> Key: GEODE-4301
> URL: https://issues.apache.org/jira/browse/GEODE-4301
> Project: Geode
> Issue Type: Improvement
> Components: querying, rest (dev)
> Reporter: Abhay Dandekar
> Priority: Major
> Labels: pull-request-available
>
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
