Table of Contents

Amazon Athena

About

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

Athena query engine is based on hive. See Langauge reference

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

Documentation / Reference