Hive and selecting non matching records
<p>I have two table like table A , B  , i need to select non matching records of A with B ( that is A minus B ) .
A is having multiple columns and B is single column( ID) . </p>

<p>I have tried like below but it is taking too much time </p>

<pre><code>Select * from A where A.ID &lt;&gt; ( select B.ID from B).
</code></pre>

<p>And also I have tried </p>

<pre><code>Select * from A left outer join on B where A.ID = B.ID AND B.ID IS NULL 
</code></pre>

<p>It's showing me wrong result </p>

<p>Please help me to identify solution to this .</p>

<p>Thank you .</p>