Hello, I am trying to implement join query in HIve but I am getting error. My query is: insert overwrite table t1 select subset.* from subset s JOIN testencounter t on (t.patient_mrn =s.patient_mrn and t.encounter_date<=s.encounter_date) where s.cad=0; I am getting error as: FAILED: Error in semantic analysis: Line 1:114 Both left and right aliases encountered in JOIN Encounter_Date
What is this error I am not getting it? Pls suggest me some solution. -- Thanks and Regards, Bhavesh Shah
