title: How to insert infinity in Impala Table
body: <p>How to insert Infinity and NaN in Impala. Same test works well with Hive but throwing error in Impala.</p>
  
  <pre><code>&gt; create table z2 (x double);
  &gt; insert into z2 values (1),("NaN"),("Infinity"),("-Infinity");
  Query: insert into z1 values (1),("NaN"),("Infinity"),("-Infinity")
  ERROR: AnalysisException: Incompatible return types 'TINYINT' and 'STRING' of 
  exprs '1' and ''NaN''.
  </code></pre>
  
  <p>Can anyone tell me how to fix this for Impala.</p>