title: Loading CSV data with NaN into AWS Redshift
body: <p>I am trying to load a CSV file from AWS S3 into AWS Redshift.  The CSV file contains a line like:</p>
  
  <blockquote>
    <p>15,NaN,0</p>
  </blockquote>
  
  <p>The table was created via:</p>
  
  <blockquote>
    <p>CREATE TABLE foo (a INT, b DOUBLE PRECISION, c INT);</p>
  </blockquote>
  
  <p>And I am trying to load the table using the COPY command:</p>
  
  <blockquote>
    <p>COPY foo (a, b, c) FROM "s3://" CREDENTIALS ... CSV;</p>
  </blockquote>
  
  <p>And I get an error complaining:</p>
  
  <blockquote>
    <p>Invalid digit value 'N'</p>
  </blockquote>
  
  <p>Trying to load that same line via an INSERT statement manually works just fine:</p>
  
  <blockquote>
    <p>INSERT INTO foo (a, b, c) VALUES (15, 'NaN', 0);</p>
  </blockquote>
  
  <p>Any help would be much appreciated!</p>