Store Amazon Athena Query Results into new Table

Question

I need to store Amazon Athena query results into New Amazon Athena Table.

score 6 · Answer 1 · answered Oct 30 '18 at 14:44

6

Updates:

Athena now supports Create Table as Select Queries (CTAS). Examples are available here.

They have implemented several nice feautes, namely the ability to apply compression to outputs (GZIP, SNAPPY) and supply output format.

answered Oct 30 '18 at 14:44

Zerodf

One thing to note is that you need to be sure you remove old data when refreshing these queries – Zerodf Oct 31 '18 at 12:49

singh30 · Accepted Answer · 2020-04-27T15:37:44.870

3

Recently they have added Create Table as CTAS support to Athena.

edited Apr 27 '20 at 15:37

answered Jun 23 '18 at 06:49

singh30

2 Answers2