title: Hive. Over partition by vs Having-clause
body: <p>I have following table:</p>
  
  <pre><code>column0  column1      column2 column3 column4
  sunny    hot         high    false   no
  sunny    hot         high    true    no
  overcast hot         high    false   yes
  rainy    mild        high    false   yes
  rainy    cool        normal  false   yes
  rainy    cool        normal  true    no
  </code></pre>
  
  <p>I want to run the query with having-clause and  OVER PARTITION BY ,my query is</p>
  
  <pre><code>SELECT column0,column1,column2,count(column0) OVER (PARTITION BY column2) AS cnt FROM FF_weatherdatase1  where column0="sunny"  having cnt&gt;8
  </code></pre>
  
  <p>But hive shows :</p>
  
  <pre><code> HAVING specified without GROUP BY error.
  </code></pre>
  
  <p>please provide method to run having-clause  using over partition by condition without group by condition, thanks in advance.</p>