How to write in query

Elastic Stack Elasticsearch
1

I want to write this mysql query on my ES.

select c.* ,u.name as createrName,cj.job_title as Jobtitle,u.avathar,u.avatar_color,u.email as createrEmail from candidates as c inner join candidate_jobs as cj on cj.candidate_id = c.id inner join users as u on c.created_by = u.id where cj.job_id = 1 and owner in (1) and c.source_tags like "% nikhil mishra%"or c.source_tags like "%LinkedIn%" and source in (2) and c.tags like "%java%"or c.tags like "%html%" and c.status = "active" And c.candidate_tab = "Lead" group by c.id ORDER BY last_updated_date DESC

2

This query seems to contain a few joins. Unfortunately Elasticsearch does not support joins, so you will need to restructure your data in a way that allows it to be queried.

3

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