title: Handling NULL values in Hive
body: <p>I am trying to create a table (table 2) in Hive from another table (table 1). I am trying to exclude certain rows with NULL values and tried the following condition.</p>
  
  <pre><code>    insert overwrite table table2 partition (date = '2013-06-01')
      select column1, column 2....
      from table1
      where column1 is not NULL or column1 &lt;&gt; '';
  </code></pre>
  
  <p>However, when I try this following query with the new table I get 300+ rows with NULL vaues:</p>
  
  <pre><code>    select count(*) from table2 where column1 is NULL;
  </code></pre>
  
  <p>Could someone point to what is causing these NULL values?</p>
  
  <p>Thank you.</p>
  
  <p>Ravi</p>