title: AWS Athena. Can't use CSV manifest as a location
body: <p>I'm trying to create an external table in Athena, the problem is that the s3 bucket has different files in the same folder so I can't use the folder as a location. </p>
  
  <p>I can't modify the path of the s3 files but I have a CSV manifest, I was trying to use it as a location but Athena didn't allow me to do that.</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE EXTERNAL TABLE `my_DB`.`my_external_table`(
      column1 string,
      column2 string
    )
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
  WITH SERDEPROPERTIES (
     'separatorChar' = ',',
     'quoteChar' = '\"',
     'escapeChar' = '\\'
     )
  STORED AS INPUTFORMAT 
    'org.apache.hadoop.mapred.TextInputFormat' 
  OUTPUTFORMAT 
    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
  LOCATION
    's3://mys3bucket/tables/my_table.csvmanifest'
  TBLPROPERTIES (
    'has_encrypted_data'='false', 
    'skip.header.line.count'='1')
  </code></pre>
  
  <p>Any ideas to use my manifest? or another way to solve this without Athena? The goal of using Athena was to avoid getting all the data from the CSVs since I only need few records</p>