Elasticsearch aggregations not working

[LuisDeHaro]

Issue Summary

When I try to run an aggregation query to the ES cluster directly it works, in Redash it doesn't.

Query:

{
    "query": {
        "match": {
            "user.email": "[email protected]"
        }
    },
    "aggs" : {
        "subtotal" : { "sum" : { "field" : "subtotal" } }
    },
    "size": 0
}

Expected output (when executed directly to the cluster):

{
  "took" : 6,
  "timed_out" : false,
  "_shards" : {
    "total" : 77,
    "successful" : 56,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : 5,
    "max_score" : 0.0,
    "hits" : [ ]
  },
  "aggregations" : {
    "subtotal" : {
      "value" : 592.0
    }
  }
}

Steps to Reproduce

1. Created a ES datasource successfully
2. Running the above query
3. 0 rows shown

Technical details:

• Redash Version: 6.0.0+b8537 (4780bd9)
• Browser/OS: MacOS 10.14.1, Chrome 72.0.3626.121
• How did you install Redash: Docker
• ElasticSearch version: 5.6.4

[arikfr]

Aggregations have very limited support at the moment. There is a community member currently looking into improving the support and we plan to allocate resources to this too when we finish other ongoing projects.

[LuisDeHaro]

@arikfr, thanks for your response.

I've been using Redash connected with PGSQL and it works just perfect, amazing and beautifully.

However this week creating a new data source pointing to ElasticSearch I would say: it's not useful... needs a lot of improvement in order to just do the job.

I hope this get's fixed soon, I would like to use Redash for every data source I have now and in the future.

God bless Israel my friend.

[lkm]

@arikfr I wouldn't mind lending a hand to code and test this. Could you please point me to the community member's code so I don't repeat anything?