title: Hive Failed SemanticException
body: <pre><code>Hive vertion:apache-hive-2.3.0
  hive&gt; select TAG_EMOTION_KEY AS key,count(1) AS cnn from NB_ORDER_RATE_EMOTION t  where t.cnn&gt;10 group by TAG_EMOTION_KEY ;
  FAILED: SemanticException [Error 10002]: Line 1:84 Invalid column reference 'cnn' 
  </code></pre>
  
  <p>what's the reason?</p>