hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhavesh Shah <>
Subject Regarding the error in Hive query
Date Wed, 04 Jan 2012 06:16:50 GMT
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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message