title: error while inserting data into hive using condition
body: <p>hi I need to insert values into a new table (consist of 3 colunms) where I have a column named verad_id which has 250 values and now while inserting data i need to load all the values expect for 6 verad_id which has zero values for reage field.</p>
  
  <p>example main table:-</p>
  
  <pre><code>verad_id   reage  value
   998        0      38
   8484       4      43
   998        3      33
   432        0      23
   233        43     26
   556        0      53
   432        9      33
  </code></pre>
  
  <p>now i need to insert values expect for   verad_id 998 and 432 which has reage value as 0 </p>
  
  <p>after inserting table should be like this </p>
  
  <pre><code>verad_id   reage  value
   8484       4      43
   998        3      33
   233        43     26
   556        0      53
   432        9      33
  </code></pre>
  
  <p>I have tried this but not working </p>
  
  <p>tried case 1:-</p>
  
  <pre><code>insert into finaltable
  select
  verad_id,
  reage,
  value
  from main_table where  verad_id = '998' or verad_id = '432' and reage != 0;
  </code></pre>
  
  <p>tried this but this query is not working </p>
  
  <p>tried case 2:-</p>
  
  <pre><code>insert into finaltable
  select
  verad_id,
  reage,
  value
  from main_table where  verad_id in ( '998' , '432') and reage != 0;
  </code></pre>
  
  <p>in this case I was able to load data of verad_id '998' and '432' with reage not equal to  0 here i am missing data of other verad_id.</p>
  
  <p>can any one please help me with this </p>