title: AWS S3 - Athena without gz compression
body: <p>I'm creating a table with the following statement in AWS Athena:</p>
  
  <pre><code>CREATE TABLE table2
  WITH 
  (
    format='JSON',
    external_location='s3://bucket/path'
  ) AS
  SELECT field1, field2, field3, field4, field5, field6
  FROM table1
  ORDER BY field1, field2
  </code></pre>
  
  <p>However, when I look into external_location, I see that all the files are compressed into gz format. Is it possible to turn off compression? That is, just write raw JSON to the S3 bucket.</p>