title: Hive - Check query result against existing value set
body: <p>I have a table like the following format.</p>
  
  <pre><code>product type    category    storecode
  apple   F      fruit           m
  tomato  v      vegetable       s
  grapes  F      fruit           m
  avacado v      vegetable       s
  bread   b      bakery          m
  </code></pre>
  
  <p>I need to query the distinct 'type' and 'storecode' to verify that I have the result match with a predefined set of type=F,V,B,C,M and storecode=m,s. It can be in seperate queries to validate type and storecode.</p>
  
  <p>I can use hive,shell,awk - Can you please suggest the best approach?</p>