[
https://issues.apache.org/jira/browse/GEODE-4301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16329265#comment-16329265
]
Jason Huynh commented on GEODE-4301:
------------------------------------
There are a few ways you might be able to do this already...
Can you use projection in your query? instead of "select * from /region" , use
"select e.getKey() from /region.entries e"
If the key is embedded into the object then you could do "select theKey from
/region"
> 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
>
> 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)
