title: How do I do a LEFT join on INEQUALITY condition in Hive
body: <p>I need to implement a left join on</p>
  
  <p><code>TABLE A: id(1,2,3); value(A,B,C)<br>
   TABLE B: id(2,3); value(E,F)</code></p>
  
  <p>and write a join that gives me,</p>
  
  <p><code>TABLE C: A.id(1,2,3); B.id(NULL,NULL,2); A.value(A,B,C);  B.value(NULL,NULL,E)</code></p>