title: Need to skip CSV header when reading from s3
body: <p>when i'm trying to load csv file from s3, headers are injecting into columns. i tried to skip header by</p>
  
  <pre><code>   TBLPROPERTIES (
      "skip.header.line.count"="1")
  </code></pre>
  
  <p>But still no use. 
  Any advice please?</p>
  
  <pre><code>CREATE EXTERNAL TABLE skipheader(
    permalink string, 
    company string, 
    numemps bigint, 
    category string, 
    city string, 
    state string, 
    fundeddate string, 
    raisedamt bigint, 
    raisedcurrency string, 
    round string)
  ROW FORMAT DELIMITED 
    FIELDS TERMINATED BY ',' 
  STORED AS INPUTFORMAT 
    'org.apache.hadoop.mapred.TextInputFormat' 
  OUTPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
  LOCATION
    's3://bucketname/filename/'
    TBLPROPERTIES (
      "skip.header.line.count"="1")
  </code></pre>