Skip to content

Instantly share code, notes, and snippets.

@Gatsby-Lee

Gatsby-Lee/aws_athena_ create_table_with_file_format.sql

Last active August 21, 2022 05:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Gatsby-Lee/4af25bdb6134c24f54f4a84f6e89a755 to your computer and use it in GitHub Desktop.
Save Gatsby-Lee/4af25bdb6134c24f54f4a84f6e89a755 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aws_athena_ create_table_with_file_format.sql
-- It's all EXTERNAL TABLE
-- default file format: TEXTFILE
CREATE TABLE my_db.default_default (
clsuter_id string
)
LOCATION 's3://aws-athena/my_db/default_default'
CREATE TABLE my_db.parquet_default (
clsuter_id string
)
STORED AS PARQUET
LOCATION 's3://aws-athena/my_db/parquet_default'
CREATE TABLE my_db.orc_default (
clsuter_id string
)
STORED AS ORC
LOCATION 's3://aws-athena/my_db/orc_default'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment