"select * where field1 != field2" in Elastic Query DSL?

Elastic Stack Elasticsearch
1

Sorry, too many years with SQL, can you give me a hint if this is possible in Elastic?

Thanks
bluepuma

2

I don't think it is possible (i'm not 100% sure). You probably have to make a script-query (slow) or have another "field1equalto2" boolean column.

3

It is not, you cannot compare fields in the DSL.