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

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


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.

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