Skip to content

Instantly share code, notes, and snippets.

@nikkisharma536

nikkisharma536/script.sql

Created December 28, 2018 11:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nikkisharma536/0512f9f1ad0365955d66fd8f18fce3c3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nikkisharma536/0512f9f1ad0365955d66fd8f18fce3c3 to your computer and use it in GitHub Desktop.
Download ZIP
SQL script
Raw
script.sql
##Creating schema:
CREATE SCHEMA IF NOT EXISTS <schema_name>;
#Creating table:
CREATE EXTERNAL TABLE IF NOT EXISTS <schema_name.table_name>
(<column_name> STRING)
LOCATION 's3a://<your-S3-bucket>/raw/access-log/2018-12-28/';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment