Athena & ALB Log Analysis
Rob Witoff

Diving into Athena today, but with some JSON data. Very annoying so far :).

Anyways, your post has been very helpful. One quick thing though, when you’re creating your partition for December 2016, I think you need to specify a value for the month, too? In your example you have month=”*”.

ALTER TABLE web_alb add partition (year=”2016", month=”12", day=”*")
location “s3://{{BUCKET}}/AWSLogs/{{ACCOUNT}}/elasticloadbalancing/us-east-1/2016/12/”;

I could be confused though, so interested in your thoughts either way!

Like what you read? Give Matt Adorjan a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.