· 8 years ago · Jan 16, 2018, 01:46 AM
1create table if not exists schema.test
2using PARQUET
3partitioned by (year, month)
4location 's3a://path/to/location'
5as select '1' test1, true test2, '2017' year, '01' month
6
7create external table if not exists schema.test
8(test1 string, test2 boolean)
9partitioned by (year string, month string)
10stored as PARQUET
11location 's3a://path/to/location'