How to update or insert data using Athena?

0 votes
How can I update the table and insert new entries using Athena? Can someone help me with the commands? Thank you in advance.
Jan 17 in AWS by Anjali
• 2,900 points
72 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
Athena is a query language and as of now does not support most of the DCL commands.

You can find a list of commands that are allowed in Athena here in the documentation provided by Amazon:-

https://docs.aws.amazon.com/athena/latest/ug/functions-operators-reference-section.html

If you need to insert data in your table you will have to update that in your csv,json file re-upload it and create new table for the same.

Hope this helps you.
answered Jan 17 by Edureka
• 4,180 points

Related Questions In AWS

+1 vote
1 answer

How to load CSV data to RDS Aurora table using lambda?

Launch an Amazon RDS MySQL database engine ...READ MORE

answered Jul 26, 2018 in AWS by Priyaj
• 56,140 points
821 views
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How to delete / drop multiple tables in AWS athena?

It is not possible to run multiple ...READ MORE

answered Jan 17 in AWS by Edureka
• 4,180 points
249 views
0 votes
1 answer

How to reduce bill for Athena?

You can save almost 90% on your ...READ MORE

answered Jan 17 in AWS by Edureka
• 4,180 points
30 views

© 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.