Amazon Athena

> Database

1 - About

Amazon Athena is an query service against data in Amazon S3.

Athena query engine is based on hive. See Langauge reference

Advertising

3 - Example

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/';

4 - Documentation / Reference