title: COALESCE with Hive SQL
body: <p>Since there is no <code>IFNULL</code>, <code>ISNULL</code>, or <code>NVL</code> function supported on Hive, I'm having trouble converting NULL to 0.  I tried <code>COALESCE(*column name*, 0)</code> but received the below error message:</p>
  
  <blockquote>
    <p>Argument type mismatch 0: The expressions after COALESCE should all
    have the same type: "bigint" is expected but "int" is found</p>
  </blockquote>
  
  <p>How to resolve this?</p>