title: Hive query with except conditions
body: <p>I am trying to build a hive query that does only the below features or a combination of these features. For example, the features include</p>
  
  <p>name = "summary"</p>
  
  <p>name = "details"</p>
  
  <p>name1 = "vehicle stats"</p>
  
  <p>Basically, the query should exclude all the other features in name and name1. </p>
  
  <p>I am quite new to hive. In sql, i know this can be done using except keyword. Just wondering whether there is some functions that can achieve the same.</p>
  
  <p>Thanks very much !!</p>