Amazon Athena
Table of Contents
Overview
CREATE EXTERNAL TABLE IF NOT EXISTS mydb.mytable (
`@project_version` string,
`time` string,
`level` int,
`level_name` string,
`host` string,
`pid` string,
`node_id` string,
`channel` string,
`message` string,
`exc_info` string
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
'serialization.format' = '1'
) LOCATION 's3://mybucket/folder/'
TBLPROPERTIES ('has_encrypted_data'='false');