About
Amazon Athena is an query service against data in Amazon S3.
Athena query engine is based on hive. See Langauge reference
Articles Related
Example
An external table based on json
CREATE EXTERNAL TABLE IF NOT EXISTS wildrydes (
Name string,
StatusTime timestamp,
Latitude float,
Longitude float,
Distance float,
HealthPoints int,
MagicPoints int
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
LOCATION 's3://YOUR_BUCKET_NAME_HERE/';