Unsupported Query in Elasticsearch

1

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?

2

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

3

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