· 9 years ago · Dec 10, 2016, 03:45 PM
1CREATE SCHEMA IF NOT EXISTS common;
2
3CREATE EXTERNAL TABLE IF NOT EXISTS common.calendar
4(
5 dt date,
6 week_num int
7)
8PARTITIONED BY(year int)
9STORED AS orc
10LOCATION 's3://YOUR_S3_LOCATION/'
11tblproperties ("orc.compress"="SNAPPY");