y0GNDkJv

1CREATE EXTERNAL TABLE IF NOT EXISTS データベース名.テーブル名 (
2 version int,
3 account string,
4 interfaceid string,
5 sourceaddress string,
6 destinationaddress string,
7 sourceport int,
8 destinationport int,
9 protocol int,
10 numpackets int,
11 numbytes bigint,
12 starttime int,
13 endtime int,
14 action string,
15 logstatus string
16) 
17PARTITIONED BY (dt string)
18ROW FORMAT DELIMITED
19FIELDS TERMINATED BY ' '
20LOCATION 's3://バケット名/AWSLogs/アカウント番号/vpcflowlogs/ap-northeast-1'
21TBLPROPERTIES ("skip.header.line.count"="1");