# Dremio 3 and ElasticSearch 2.3.5

**URL:** <https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782>\
**Category:** Uncategorized\
**Created:** [February 14, 2019, 7:22pm UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782 "2019-02-14T19:22:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nlippey](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nlippey](https://community.dremio.com/u/nlippey)\
**Post date:** [February 14, 2019, 7:22pm UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782/1 "2019-02-14T19:22:31Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/e/e69cf86053e264d8e1d1bbaeb1242edaa8e3bcdf.png)  
Unfortunately we can’t update our version of ElasticSearch, is there anything we can do to get around this?

---

<div class="post-metadata">

**Author:** ![firefly707](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/firefly707/32/646_2.png) [@firefly707](https://community.dremio.com/u/firefly707)\
**Post date:** [February 14, 2019, 7:30pm UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782/2 "2019-02-14T19:30:17Z")

</div>

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](https://docs.dremio.com/release-notes/30-release-notes.html#data-sources).

---

<div class="post-metadata">

**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\
**Post date:** [February 14, 2019, 7:39pm UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782/3 "2019-02-14T19:39:04Z")

</div>

@nlippey,

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.

 ![18%20AM](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/b/bf079149768e71c92dac4654ec0cccc9d1050273.png)

---

<div class="post-metadata">

**Author:** ![nlippey](https://avatars.discourse-cdn.com/v4/letter/n/839c29/32.png) [@nlippey](https://community.dremio.com/u/nlippey)\
**Post date:** [February 15, 2019, 3:33pm UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782/4 "2019-02-15T15:33:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![firefly707](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/firefly707/32/646_2.png) [@firefly707](https://community.dremio.com/u/firefly707)\
**Post date:** [August 9, 2019, 5:52am UTC](https://community.dremio.com/t/dremio-3-and-elasticsearch-2-3-5/2782/5 "2019-08-09T05:52:04Z")

</div>