title: Hive Query- Joining two tables on three joining conditions with OR operator
body: <p>I am facing an error </p>
  
  <p>"<code>FAILED: Error in semantic analysis: Line 1:101 OR not supported in JOIN currently dob</code>"</p>
  
  <p>while running the below mentioned query..</p>
  
  <pre><code>Insert Overwrite Local Directory './Insurance_Risk/Merged_Data' Select f.name,s.age,f.gender,f.loc,f.marital_status,f.habits1,f.habits2,s.employement_status,s.occupation_class,s.occupation_subclass,s.occupation from sample_member_detail s Join fb_member_detail f 
  On s.email=f.email or 
  s.dob=f.dob 
  or (f.name=s.name and f.loc = s.loc and f.occupation=s.occupation)
  where s.email is not null and f.email is not null;
  </code></pre>
  
  <p>Can anyone tell me that, in hive "<code>OR</code>" operator can be used or not?
  if not, then what should be the query which will give the same result as given by the above mentioned query.
  I have 2 tables and I want to join the two tables on any one of the three conditions with or operator.
  Please help..</p>