Ordering of two fields in ELastic, specifically first one is of text and second is from integer

Hi Team,
Could someone please show hints to implement the below requirement?
I have an index where two fields, first one is text field, and second is of integer. I need to take the highest number row from the unique(first and second fields) using Query DSL.

FirstField, SecondField

abc, 1
abc, 2
abc. 3
dac, 1
dac, 2
dac, 5

Expected result would be:
rows (abc,3), and (dac,5).
Please shred some light of formatting the DSL query.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.