title: Hive support for subquery in Join condition?
body: <p>Error: Error while compiling statement: FAILED: SemanticException in encountered with 0 children (state=42000,code=40000)</p>
  
  <p>Do I need to find a solution to getting the subquery out of the on condition?</p>
  
  <pre><code>select
  -- a bunch of stuff min,max,sum and case statements
  from tbl0 t0
  inner join tbl4  t4  on (t4.aKey = t0.aKey)  
  left outer join tbl1  t1  on (t0.col0 = t1.col0 and t1.someKey in (select t3.aKey from tbl3 t3 where t3.someCode in ('A1','A2','A3')))
  where
  not(t4.aCode in ('string1' , 'strin2' , 'string3' , 'string4') and t1.someKey is null) and not (t4.bCode in ('string1' , 'string2') and t1.someCol = 0)
  </code></pre>