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
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
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.