title: What is the replacement of NULLIF in Hive?
body: <p>I would like to know what is the replacement of <code>NULLIF</code> in Hive? I am using COALESCE but its not serving my requirement. My query statement is something like :</p>
  
  <pre><code>COALESCE(A,B,C) AS D
  </code></pre>
  
  <p><code>COALESCE</code> will return first NOT NULL value. But my A/B/C contain blank values so COALESCE is not assigning that value to D as it is considering blank as NOT NULL. But I want the correct value to be get assign to D.</p>
  
  <p>In SQL I could have use <code>COALESCE(NULLIF(A,'')......)</code> so it will check for blank as well. I tried CASE but it's not working.</p>