需求,一个文档中有字段A B,要查询A!=B的数据?
在Mysql中可以用
select * from test where A != B
在ES中怎么实现呢?(核心代码)
String script = "doc['" + aField + ".keyword'] != doc['" + zField + ".keyword']";
BoolQueryBuilder query = QueryBuilders.boolQuery();
query .must(new ScriptQueryBuilder(new Script(script)));