title: Redshift spectrum shows NULL values for all rows
body: <p>When I run this query in Athena query editor, it works as expected.</p>
  
  <blockquote>
    <p>SELECT * FROM "sampledb"."elb_logs" limit 10;</p>
  </blockquote>
  
  <p>elb_logs table has been generated based on the official tutorial. When I try to use spectrum in redshift, I can see all "NULL" values for all columns. I am creating athena_schema using these commands:</p>
  
  <pre><code>drop schema "athena_schema";
  
  create external schema athena_schema from data catalog 
  database 'sampledb' 
  iam_role 'arn:aws:iam::94331XXXXXXX:role/RedshiftCopyUnload'
  region 'ap-south-1';
  </code></pre>
  
  <p>And the output of system table:</p>
  
  <blockquote>
    <p>select * from svv_external_tables;</p>
  </blockquote>
  
  <pre><code>schemaname  tablename   location    input_format    output_format   serialization_lib   serde_parameters    compressed  parameters
  
  athena_schema   elb_logs    s3://athena-examples-ap-south-1/elb/plaintext   org.apache.hadoop.mapred.TextInputFormat    org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat  org.apache.hadoop.hive.serde2.RegexSerDe    {"input.regex":"([^ ]*) ([^ ]*) ([^ ]*):([0-9]*) ([^ ]*):([0-9]*) ([.0-9]*) ([.0-9]*) ([.0-9]*) (-|[0-9]*) (-|[0-9]*) ([-0-9]*)     0   {"EXTERNAL":"TRUE","transient_lastDdlTime":"1480278335"}
  </code></pre>
  
  <p>I am not sure why the athena console shows the correct values for all columns while redshift shows all NULLs?</p>