Aggregation running very slow

[mavencode01]

I'm using sparkSQL to query ES but aggregation (GROUP BY) is running very slow. I can't remember but seems I read that aggregation queries are also push down to ES. If that's the case, why is aggregation running so slow and how can I improve that ?

[costin]

Please don't copy forum questions over to the issue tracker. Thank you.