-- LTSV Λ Athena ͰΫΤϦ͢ΔͨΊʹύʔεͯ͠ΈΑ͏
CREATE EXTERNAL TABLE IF NOT EXISTS `sugoi-service-logs` (
`time` string,
`host` string,
`method` string,
`path` string,
`taken_sec` float,
`ua` string,
`referer` string
)
PARTITIONED BY (date string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
'serialization.format' = '1',
'input.regex' = '^time:([^\\t]*)\\thost:([^\\t]*)\\tmethod:([^\\t]*)\\turi:
([^\\t]*)\\ttaken_sec:([^\\t]*)\\tua:([^\\t]*)\\treferer:([^\\t]*)$'
) LOCATION 's3://your-logs-bucket/sugoi-service-logs/'
TBLPROPERTIES ('has_encrypted_data'='false')