title: How to use MINUS operator in Impala/Hive?
body: <p>How can I use a MINUS operator query in Impala?</p>
  
  <p>Example:</p>
  
  <p><strong>Table:</strong> Game</p>
  
  <p><strong>Columns:</strong> Official_start, halftime_start</p>
  
  <p>I want to send a query in which halftime_start - official_start and save it as firsttimeplayed</p>
  
  <p>I know that MINUS does not exist in Impala or HIVE but how can I do it without it?</p>