gistfile1.txt

// from https://medium.com/@dnorth98/analyzing-papertrail-logs-with-aws-athena-2427d3dd14f2#.nijavm26w


drop table papertrail.papertrail_logs;

CREATE EXTERNAL TABLE IF NOT EXISTS papertrail.papertrail_logs (
 `id` bigint,
 `generated_at` string,
 `received_at` string,
 `source_id` bigint,
 `source_name` string,
 `source_ip` string,
 `facility_name` string,
 `severity_name` string,
 `program` string,
 `message` string 
)
PARTITIONED BY (dt string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
 'serialization.format' = ' ',
 'field.delim' = "\t"
) LOCATION 's3://org-global-papertrail-archive/papertrail/logs/12345/';

MSCK REPAIR TABLE papertrail_logs;