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 seman
(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 wrote:
> Hello,
> I am trying to implement join query