title: How do you group OR clause in WHERE statement using HIVE
body: <p>I would like to query by the following</p>
  
  <pre><code>(statement1 AND statement2 AND (statement3 OR statement4 ))
  </code></pre>
  
  <p>this is my hive query, I verified that it doesn't work since it only returns statement3, and I know there are case where statement4 is true</p>
  
  <pre><code>SELECT 
    cid,
    SUM(count) AS total_count
  FROM
    count_by_day
  WHERE
    time &gt;= 1435536000
    AND time &lt; 1436140800
    AND(
      cid = '4eb3441f282d4d657a000016'
      OR cid = '14ebe153121a863462300043d'
    )
  GROUP BY
    cid
  </code></pre>
  
  <p>Can someone tell me what is wrong? Thanks</p>