Simple sql type query in multiple index

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! OR a.price!=b.price"

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

No you can’t do that.

Anything similar? using script or something?

Two ideas:

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

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