Oracle Coherence CohQL - limit results

Question

Is there a way to limit results of CohQL query?

My Coherence cache contains million records and it would be very useful to just limit the number of records if I just want to see how a specific entry looks like. for e.g. something like

select top 10 key() from cache

I don't find any such option in CohQL docs.

It's not possible with cohql. You can write your own java app and use a LimitFilter.... — Paul Creasey, Jan 20 '15 at 14:12

score 0 · Answer 1 · answered Dec 28 '14 at 03:08

0

ok, so its quite simple... do select top 10 * from <cache-name>

answered Dec 28 '14 at 03:08

Rohit

848
3
15
31

yeah, it doesn't work for me either, for some cache...not sure why. – Rohit Apr 01 '15 at 13:08

score 0 · Answer 2 · edited May 23 '17 at 12:04

As mentioned in the comments, this is not possible using CohQL but this can be achieved using LimitFilter in Java. Based on your question, you are expecting top results without specifying any order.

Here is an example on how to use LimitFilter from documentation with order by Age desc. If you want your results in random order, you will have to implement the EntryFilter interface to return random entry and use it instead of GreaterEqualsFilter in the example.

Oracle Coherence CohQL - limit results

2 Answers2