title: How to create an uncompressed text file with Athena
body: <p>I have some data in Athena and I want to join and create a new table. I can do that with as CTAS operation, and <a href="https://docs.aws.amazon.com/athena/latest/ug/ctas-examples.html#ctas-example4" rel="nofollow noreferrer">AWS provide a few examples</a>.</p>
  
  <p>I'm create output with the <code>TEXTFILE</code> format, and I don't want any compression. In this link </p>
  
  <blockquote>
    <p>This example also specifies compression as SNAPPY. If omitted, GZIP is used.</p>
  </blockquote>
  
  <p>Here's an example of my code:</p>
  
  <pre><code>CREATE TABLE "main_extended"
  WITH (
      external_location = 's3://attr-dev/data-joiner/test-1/main_extended/',
      format = 'TEXTFILE',
      field_delimiter = ',')
  AS
  SELECT
      t1.*,
      t2.month
  FROM main t1 left outer join period_month t2
  ON t1.period = t2.period
  </code></pre>
  
  <p>How do I specify the <code>compression</code> option, and what value should that option take to 'turn off' compression for <code>TEXTFILE</code> format?</p>