title: Minus query in HIVE
body: <p>Minus query seems to not work in HIVE.</p>
  
  <p>Tried ex: </p>
  
  <pre><code>select x from abc 
  minus 
  select x from bcd ; 
  </code></pre>
  
  <p>Am I doing this wrong or minus query isn't defined for HIVE? If so, is there any other way to get the result for this?</p>