How to store Amazon Athena Query Results into new Table?

0 votes
I need to store Amazon Athena query results into New Amazon Athena Table. Can someone help me with this?
Jan 16 in AWS by Anjali
• 2,900 points
207 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

This is not supported by Athena as Amazon Athena does not support INSERT or CTAS (Create Table As Select) queries.

Amazon athena stores query result in S3. Here is a documentation on how Athena works. https://docs.aws.amazon.com/athena/latest/ug/querying.html

As Athena only points to data in S3. So once results are in S3, you can use athena to point to this as a new table.

answered Jan 16 by heena

Related Questions In AWS

+1 vote
1 answer
0 votes
1 answer

How to skip headers when reading a CSV file in S3 and creating a table in AWS Athena?

This is a known deficiency. The best ...READ MORE

answered Sep 4, 2018 in AWS by Archana
• 4,090 points
617 views
0 votes
1 answer

How to upload an object into Amazon S3 in Lambda?

I suspect you are calling the context.done() function before s3.upload() has ...READ MORE

answered Sep 27, 2018 in AWS by Archana
• 4,090 points
29 views
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How to convert String to Date in Amazon Athena?

You can use date_parse. All you need ...READ MORE

answered Jan 16 in AWS by chandan
635 views
0 votes
1 answer

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.