Elasticsearch source uses deprecated field "fields"

[cogfor]

I am trying to use Redash with Elasticsearch 5.1 (on Amazon). Every simple query that involves selecting some fields fails reporting the error message "Deprecated field [fields] used, expected [stored_fields] instead". I assume this is because the Elasticsearch plugin code was not updated for recent versions of Elasticsearch.

Issue Summary

A clean install from source (5ba6af6) does not work with Elasticsearch V5.1 and higher due to deprecated "fields" field in query.

Steps to Reproduce

1. Every query that uses the "fields" field doesn't work regardless the chosen Elasticsearch index

Technical details:

• Redash Version: master (5ba6af6)
• Browser/OS:
• How did you install Redash: from source, running in docker according to the instructions.

[arikfr]

I'm not 100% familiar with the ElasticSearch query runner code, but from what I can see, you don't have to use the fields field.

The examples include it, but if you use the Elastic Search type data source (and not Kibana), you can pass ElasticSearch's Query DSL JSON, including stored_fields.