(moving to user@hive, bcc'ing dev@hive) Hi Bhavesh -
Hive only supports equality conditions for joins. See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins cheers, -James On Tue, Jan 3, 2012 at 10:16 PM, Bhavesh Shah <bhavesh25s...@gmail.com>wrote: > 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 >
