Is there size limit in sql with group by?

Elastic Stack Elasticsearch
1

When I translate my sql, I've been seeing size with 1000 limit.

"aggregations" : {
"groupby" : {
"composite" : {
"size" : 1000,
"sources" : [
{

And it shows limited result.
After I search with translated DSL, which is manipulated size to 100000, it shows data which I expected.

Is there anyone knows about it? and can you guys help me this out?
How can I ignore the limit.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.