· 8 years ago · Jul 30, 2018, 12:14 PM
1CREATE EXTERNAL TABLE IF NOT EXISTS sns_delivery_status_logs (
2 status string,
3 notification struct<
4 timestamp:string,
5 messageId:string>,
6 delivery struct<
7 statusCode:int,
8 dwellTimeMs:int,
9 token:string,
10 attempts:int,
11 providerResponse;string,
12 destination:string>
13)
14ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
15LOCATION 's3://your_log_bucket/prefix/';