Skip to content

Instantly share code, notes, and snippets.

@abbr

abbr/gist:4d5367a058bfd1811e44a71117c4e2d1

Created January 15, 2020 23:07
Show Gist options
  • Save abbr/4d5367a058bfd1811e44a71117c4e2d1 to your computer and use it in GitHub Desktop.
Save abbr/4d5367a058bfd1811e44a71117c4e2d1 to your computer and use it in GitHub Desktop.
Download ZIP
Athena create partitioned parquet table from existing (external) table
Raw
gistfile1.txt
CREATE TABLE test_parquet
WITH ( format = 'PARQUET', parquet_compression = 'SNAPPY', external_location = 's3://<bucket>/parquet/test', partitioned_by = ARRAY['office_id'] )
AS
SELECT *
FROM test
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment