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=”*")
I could be confused though, so interested in your thoughts either way!