Hive query not working

Question

select distinct HHU.FirstName, HHU.LastName , HHU.Email as UserEmail, HHU.Created as UserCreateDate, HHU.LastLogin , HHR.JobTitle as ResumeTitle, hhr.did,hhr.Created as ResumeCreatedDate,reh.EndDateText as LastTitleEndDate,kd.ONet17 as Onet

from SiteData.hhtvuser HHU

inner join ResumeData.hhresume HHR on HHR.UserDID = HHU.DID

inner join audit.developerserviceaudit dau on dau.resourcedid = HHR.DID

left join (

select resumedid,EndDateText,

row_number() over(partition by resumedid order by enddatetext desc) as rn

from

ResumeData.ResumeEmploymentHistory

) reh on HHR.DID = reh.ResumeDID and reh.rn = 1

left join knowledgediscovery.resumeevidence kd on HHR.DID = kd.resumedid

where HHU.ClassList like '%RPSW%' and hhu.created like '2019-04-13%' AND dau.yomo >= '2019-04'