title: Hive - Explode in JOIN Condition
body: <p>I want to do explode on a column in a join condition. </p>
  
  <pre><code>select
  t1.a,t2.b, t2.c
  from table1 AS t1
  join (select b,LATERAL VIEW explode(ABCD) AS c from person) AS t2 ON (t1.c=t2.c)
  </code></pre>
  
  <p>But, this query is failing. I suspect the subquery is not working as expected. 
  In the subquery, I have selected two columns, one is column b and another is column c, which is an explode. </p>
  
  <p>Is this way of writing subquery is correct? If wrong, how can I achieve this.</p>
  
  <p>Error:</p>
  
  <pre><code>Error while compiling statement: FAILED: SemanticException Cannot do equality join on different types: string and map&lt;bigint,array&lt;string&gt;&gt;
  </code></pre>