Currently elasticsearch adapters ignore records which do not have the field specified in NotEqual clause, which is ideally included by elasticsearch.
The elasticsearch query formed for above is this :
Problem : The above query ignores document which do not have Name field which is ideally included by elasticsearch but ignored due to must exists condition.
RelNode for same -
Solution : Remove the exists condition from Not equals Query Expression. Elasticsearch doesn't put this condition therefore keeping queries in sync. Code