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'