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,930 points
653 views

1 answer to this question.

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,900 points
1,380 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
758 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
43 views