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, 2019 in AWS by Anjali
• 2,950 points
12,103 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, 2019 by Edureka
• 4,220 points

Related Questions In AWS

+1 vote
1 answer
+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
• 58,020 points
4,678 views
0 votes
1 answer
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, 2019 in AWS by Edureka
• 4,220 points
8,235 views
0 votes
1 answer

How to reduce bill for Athena?

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

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
833 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP