Athena CTAS Update
An approach for updating partitions in an existing table using CTAS queries.
With the release of CTAS functionality for Athena, you're now able to create derivative tables in Athena with different data formats or S3 locations.
Sometimes, though, you want to be able to add data to a partition of an existing table. As long as that partition doesn't already exist, you can do this with Athena by using CTAS with a temporary table.