Simple sql type query in multiple index

Elastic Stack Elasticsearch
1

Hello,
Sorry to bother you guys. I've searched a lot and couldn't find a concrete answer regarding multiple index search. I know elasticsearch does not do well with join type query. Still I want to know if there is any way to query the below syntax in ES.

> "Select * from table1 a, table2 b where a.no!=b.no OR a.price!=b.price"

It'd be really helpful if anyone could direct me to the right path. TIA.

2

No you can’t do that.

3

Anything similar? using script or something?

4

Two ideas:

  • change the way you model your data and solve most of the problems at index time
  • use parent / child feature
5

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