Bug - Elasticsearch connector - query incl. Count & Filter: wrong sum

[jimPeill]

The result of the following SQL query on an elasticsearch database :
Select count(*) from table_z where x=y;

is not equal to the result of the related ES query:

curl get table_z/_count?
query bool filter term x: value:y

I get more lines through the SQL query

[findinpath]

Do you have a reproduction scenario?

[hashhar]

@jimPeill gentle reminder in case you have a reproduction scenario.