827K9zV4

1##Creating schema:
2CREATE SCHEMA IF NOT EXISTS <schema_name>;
3
4#Creating table:
5CREATE EXTERNAL TABLE IF NOT EXISTS <schema_name.table_name>
6(<column_name> STRING)
7LOCATION 's3a://<your-S3-bucket>/raw/access-log/2018-12-28/';