Temporary table alternative in elastic search

Elastic Stack Elasticsearch
1

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
JOIN
(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

2

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?

3

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.

4

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