title: I wanted to check if a column value is not a decimal in Hive
body: <p>I have a table with columns like</p>
  
  <pre><code>S.No Product Quantity
   1  Chair   1
   2  Table   3
   3  Fan     2.4
  </code></pre>
  
  <p>I wanted to have a check to see if quantity column is not negative. If it's negative it should not return the row.
  I want the result only first two rows 1 &amp; 2
  Please suggest me how to come up with the query in Hive which returns only not decimal values</p>