I have below scenario: Suppose I have a relational table :
Key1 Key2 Key3 Value A x v1 0 A x v1 10 B x v1 5 A y v2 7 A y v2 2
Here I have logical key composite of (Key1, Key2, Key3). Now I need records with the maximum value. So I expect below result corresponding to different logical keys:
Key1 Key2 Key3 Value A x v1 10 B x v1 5 A y v2 7
Now I want to write an Elastic Search query for it. Can somebody give me some idea about it ?