Dremio 3 and ElasticSearch 2.3.5

We just updated Dremio to v3 (because it wasn’t talking to the latest version of Tableau Desktop for Mac) and now Dremio isn’t speaking to ElasticSearch properly. It can run a simple select statement, but as soon as a ‘Where’ clause is added we get this error image
Unfortunately we can’t update our version of ElasticSearch, is there anything we can do to get around this?

I don’t believe there’s any workaround here as Dremio currently supports Elasticsearch versions 5.x, 6.0, 6.2, and 6.3. It was release noted here: https://docs.dremio.com/release-notes/30-release-notes.html#data-sources.


You may have some success if you disable any script pushdowns when configuring the Elasticsearch source. In the image below I have scripting enabled by checking those boxes. If you haven’t already, uncheck to disable script pushdowns and you’re queries may work for these older versions of ES.

Thanks for the suggestion @ben. Unfortunately that didn’t work for us. We’ve had to revert to v2 of Dremio and also an older version of Tableau