Skip to content

Instantly share code, notes, and snippets.

@hakanilter

hakanilter/athena.sql

Created November 8, 2018 13:04
Show Gist options
  • Save hakanilter/aaf4babde0d8e7d521e4273c932cf900 to your computer and use it in GitHub Desktop.
Save hakanilter/aaf4babde0d8e7d521e4273c932cf900 to your computer and use it in GitHub Desktop.
Download ZIP
Athena create select query with location
Raw
athena.sql
CREATE TABLE sampledb.test_empty_array_parquet
WITH (
format = 'PARQUET',
external_location = 's3://somewhere'
)
AS SELECT *
FROM sampledb.test_empty_array
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment