AWS Athena – DML Queries

Posted Leave a commentPosted in AWS, AWS Athena

You can learn something new everyday, and today I learned that AWS Athena supports INSERT INTO queries. Lets create table based on marvel_superheroes using CTAS command – Creating the table partition based on “year” failed with : HIVE_COLUMN_ORDER_MISMATCH: Partition keys must be the last columns in the table and in the same order as the […]