hive-dev mailing list archives

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

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