Is pagination possible in termsStatsFacet?

Elastic Stack Elasticsearch
1

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30 ...

Pagination is possible in QueryBuilder. Just wondering if its possible in
termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam

2

No, there isn't an option to paginate the results of a terms / terms stats
facets. You need to ask for a bigger size.

On Fri, Oct 14, 2011 at 11:51 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30 ...

Pagination is possible in QueryBuilder. Just wondering if its possible in
termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam

3

Thanks Shay for confirmation!

I tried using QueryBuilder to paginate and fetch paginated terms to restrict
the termsStatsFacet result.
But then it prohibits from ordering the data on "Total". Which is why I now
relying on a fake pagination where I just keep increasing the size.

The problem is that, as unique terms increases the performance of
termsStatsFacet degrades quiet drastically.
Any plans to support pagination in near future?

Thanks
Gautam

On Sat, Oct 15, 2011 at 3:48 PM, Shay Banon kimchy@gmail.com wrote:

No, there isn't an option to paginate the results of a terms / terms stats
facets. You need to ask for a bigger size.

On Fri, Oct 14, 2011 at 11:51 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30 ...

Pagination is possible in QueryBuilder. Just wondering if its possible in
termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam

--
Gautam
Co-Founder, DataRPM
+91 9886021223 | gautam@datarpm.com ruban@datarpm.com | http://datarpm.com
*DataRPM http://datarpm.com/: Stay Connected With Your Business Data!!
*

4

Do you mean that for the same search request, with just a different size for
the terms stats, you see a big difference in performance? What are those
different sizes that you test on?

On Sat, Oct 15, 2011 at 12:36 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Thanks Shay for confirmation!

I tried using QueryBuilder to paginate and fetch paginated terms to
restrict the termsStatsFacet result.
But then it prohibits from ordering the data on "Total". Which is why I now
relying on a fake pagination where I just keep increasing the size.

The problem is that, as unique terms increases the performance of
termsStatsFacet degrades quiet drastically.
Any plans to support pagination in near future?

Thanks
Gautam

On Sat, Oct 15, 2011 at 3:48 PM, Shay Banon kimchy@gmail.com wrote:

No, there isn't an option to paginate the results of a terms / terms stats
facets. You need to ask for a bigger size.

On Fri, Oct 14, 2011 at 11:51 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30 ...

Pagination is possible in QueryBuilder. Just wondering if its possible in
termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam

--
Gautam
Co-Founder, DataRPM
+91 9886021223 | gautam@datarpm.com ruban@datarpm.com |
http://datarpm.com
*DataRPM http://datarpm.com/: **Stay Connected With Your Business Data!!

5

Yes for the same search request the performance degrades if I don't limit
the size.

I have indexed about 1 million documents, each document is of 10 kb.
Runs on one node with the default ES configuration.
The number of unique values are 1000+

Thanks
Gautam

On Sat, Oct 15, 2011 at 6:35 PM, Shay Banon kimchy@gmail.com wrote:

Do you mean that for the same search request, with just a different size
for the terms stats, you see a big difference in performance? What are those
different sizes that you test on?

On Sat, Oct 15, 2011 at 12:36 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Thanks Shay for confirmation!

I tried using QueryBuilder to paginate and fetch paginated terms to
restrict the termsStatsFacet result.
But then it prohibits from ordering the data on "Total". Which is why I
now relying on a fake pagination where I just keep increasing the size.

The problem is that, as unique terms increases the performance of
termsStatsFacet degrades quiet drastically.
Any plans to support pagination in near future?

Thanks
Gautam

On Sat, Oct 15, 2011 at 3:48 PM, Shay Banon kimchy@gmail.com wrote:

No, there isn't an option to paginate the results of a terms / terms
stats facets. You need to ask for a bigger size.

On Fri, Oct 14, 2011 at 11:51 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30 ...

Pagination is possible in QueryBuilder. Just wondering if its possible
in termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam

6

What are the different sizes that you use, and what is the difference
execution time wise (for the same search query). Also note, you should run
the search request several times (50) to warm things up before measuring.

On Sun, Oct 16, 2011 at 11:26 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Yes for the same search request the performance degrades if I don't limit
the size.

I have indexed about 1 million documents, each document is of 10 kb.
Runs on one node with the default ES configuration.
The number of unique values are 1000+

Thanks
Gautam

On Sat, Oct 15, 2011 at 6:35 PM, Shay Banon kimchy@gmail.com wrote:

Do you mean that for the same search request, with just a different size
for the terms stats, you see a big difference in performance? What are those
different sizes that you test on?

On Sat, Oct 15, 2011 at 12:36 PM, Gautam Shyamantak gautam@datarpm.comwrote:

Thanks Shay for confirmation!

I tried using QueryBuilder to paginate and fetch paginated terms to
restrict the termsStatsFacet result.
But then it prohibits from ordering the data on "Total". Which is why I
now relying on a fake pagination where I just keep increasing the size.

The problem is that, as unique terms increases the performance of
termsStatsFacet degrades quiet drastically.
Any plans to support pagination in near future?

Thanks
Gautam

On Sat, Oct 15, 2011 at 3:48 PM, Shay Banon kimchy@gmail.com wrote:

No, there isn't an option to paginate the results of a terms / terms
stats facets. You need to ask for a bigger size.

On Fri, Oct 14, 2011 at 11:51 PM, Gautam Shyamantak <gautam@datarpm.com

wrote:

Hi,

Is pagination possible in termsStatsFacet?
There is a way to provide the size parameter to limit the results.
Is there a way to specify the results to be sent from 11-20 or 21-30
...

Pagination is possible in QueryBuilder. Just wondering if its possible
in termsStatsFacet as well?

Would appreciate your response.

Thanks
Gautam