Temporary table alternative in elastic search

I have a scenerio where i'm filtering some records from a table and reusing the same intermediate tables to join on a column. My query looks something like this

select * from
(select poscode from test where AccountNo='270679' )AS FD
(select poscode from test where AccountNo!='270679')AS MD
ON FD.poscode=MD.poscodE
I can put two get request on my data but and get the result but how will i use the concept of temporary tables here in elastic search as i created two FD,MD in sql and put a join between them. I was able to get some info from Here but not sure how to put all that together

Any help on this would be appreciated. If someone can just give the idea whether this type of scenario could be achieved or not in elastic search?

Read this and specifically the "Also be patient" part.

It's fine to answer on your own thread after 2 or 3 days (not including weekends) if you don't have an answer.

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