create_table

CREATE EXTERNAL TABLE IF NOT EXISTS データベース名.テーブル名 (
 version int,
 account string,
 interfaceid string,
 sourceaddress string,
 destinationaddress string,
 sourceport int,
 destinationport int,
 protocol int,
 numpackets int,
 numbytes bigint,
 starttime int,
 endtime int,
 action string,
 logstatus string
) 
PARTITIONED BY (dt string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' '
LOCATION 's3://バケット名/AWSLogs/アカウント番号/vpcflowlogs/ap-northeast-1'
TBLPROPERTIES ("skip.header.line.count"="1");