title: data appears as null on redshift external table while working right on athena
body: <p>So I'm trying to run the following simple query on redshift spectrum:</p>
  
  <pre><code>select * from company.vehicles where vehicle_id is not null
  </code></pre>
  
  <p>and it return 0 rows(all of the rows in the table are null). However when I run the same query on athena it works fine and return results. Tried msck repair but both athena and redshift are using the same metastore so it shouldn't matter.
  I also don't see any errors.</p>
  
  <p>The format of the files is orc.</p>
  
  <p>The create table query is:</p>
  
  <pre><code>CREATE EXTERNAL TABLE 'vehicles'(
    'vehicle_id' bigint, 
    'parent_id' bigint, 
    'client_id' bigint, 
    'assets_group' int, 
    'drivers_group' int)
  PARTITIONED BY ( 
    'dt' string, 
    'datacenter' string)
  ROW FORMAT SERDE 
    'org.apache.hadoop.hive.ql.io.orc.OrcSerde' 
  STORED AS INPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' 
  OUTPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
  LOCATION
    's3://company-rt-data/metadata/out/vehicles/'
  TBLPROPERTIES (
    'CrawlerSchemaDeserializerVersion'='1.0', 
    'CrawlerSchemaSerializerVersion'='1.0',  
    'classification'='orc', 
    'compressionType'='none')
  </code></pre>
  
  <p>Any idea?</p>