Accessing two various indexes in canvas datatable

I want to populate a data table in canvas with this kind of query

SELECT student_id,name,address,department_id
FROM student
WHERE department_id IN (
SELECT department_id FROM department WHERE department_name ="Engineering" )

I got to know that elasticsearch does not support it, but I need suggestions to do this with scripted field or expression editor or logstash or anything.Please help

Make sur you have all attributes inside same document in elasticsearch :

  • student_id
  • name
  • address
  • department_id
  • department_name

Thanks for your response @ylasri.student and department are seperated index.without having a common index i want to have both in essql(join query or nested query).I admit that it is complex.Thankful if you can suggest me a different way

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