Unsupported Query in Elasticsearch

Latest Elasticsearch (6.2.4).

I’m trying to write a query to limit the results to a certain subset of values, so my query goes something like this:
SELECT * FROM index WHERE hostname IN (… list of values)

When Dremio tries to translate this query it results in an error: 400, [match] query does not support [type]
Issue is echo’ed here: https://discuss.elastic.co/t/match-query-does-not-support-type/111667

Is there a way I can manually change the resulting query to remove the [type] fields?

Currently Dremio supports ES 2.x and 5.x. We are expecting to add support for 6.x over the summer.

Hello, support for Elasticsearch 6.0 is now available in our latest release, Dremio 2.1. More details here.