title: Invalid digit, Value '\\', Pos 0, Type: Long error in Amazon redshift copy command
body: <p>I'm trying to unload the data from Amazon redshift table and then copying the data from s3 file to redshift by using following command.</p>
  
  <pre><code>unload ('select * from abx.xuz where src =\'vpc\'') to 's3://load/2017/' credentials 'aws_access_key_id=******;aws_secret_access_key=*****' allowoverwrite;
  
  copy abc.abxy from 's3://sumo-processed/2017/' 
  credentials 'aws_access_key_id=XXXX;aws_secret_access_key=YY' NULL AS '\\0' TRUNCATECOLUMNS FILLRECORD  maxerror as 255;
  </code></pre>
  
  <p>But it is not able load all the records. After checking the stl_load_errors table it is showing "Invalid digit, Value '\', Pos 0, Type: Long" error.</p>
  
  <p><a href="https://i.stack.imgur.com/L0eNM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/L0eNM.png" alt="enter image description here"></a></p>
  
  <p>How to resolve this error?. SO I can load all recording without skipping?</p>