What is the difference between MySQL and Athena

0 votes
I came across Amazon Athena and found it quite interesting. Athena really has lot of features and is fast but I was confused as how it is different than MySQL? Can someone help me with this?
Jan 17, 2019 in AWS by Anjali
• 2,950 points
976 views

2 answers to this question.

0 votes

Amazon Athena is an interactive data analysis tool used to process complex queries in relatively less time. It is server-less hence, there is no hassle of setting up and doesn’t require managing the infrastructure. It is not a Database service hence, you just pay for the queries you run. You just point your data in S3, define the schema required and with a standard SQL you are good to go.

MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web applications and online publishing.

To find a detailed explanation on MySQL and Athena you can go through the blog "What is Amazon Athena?"

answered Jan 17, 2019 by Edureka
• 4,220 points
0 votes

Athena does not have all the DDL commands as of now. Athena is just an analytics tool by Amazon and is used to process the query very quickly. It processes the complex query into simpler ones and then joins the result to give a faster output.

The simplest way for creating a table in Athena can be storing the CSV, JSON or your file in S3 and then point it to Athena and create a external table. Then you can perform all the different query on it.

Here is a blog on how to create a table in Athena. "What is Amazon Athena?"

Hope this helps!

answered Jan 17, 2019 by Edureka
• 4,220 points

Related Questions In AWS

0 votes
1 answer

What is the difference between Amazon Cloudfront and S3

major difference is that cloudfront allows you ...READ MORE

answered Jul 9, 2018 in AWS by Priyaj
• 58,120 points
847 views
+1 vote
4 answers

What is the difference between Amazon ECS and Amazon EC2?

EC2 allows you to launch individual instances ...READ MORE

answered Jul 11, 2018 in AWS by Priyaj
• 58,120 points
25,594 views
0 votes
2 answers

What is the difference between Amazon SNS and Amazon SQS?

Amazon SQS and SNS are the two ...READ MORE

answered Sep 9, 2020 in AWS by Michael
• 140 points
1,666 views
0 votes
1 answer

IOPS or Throughput?

Configure your database driver to print statistics ...READ MORE

answered Nov 14, 2018 in AWS by Theodor
• 740 points
115 views
0 votes
1 answer
0 votes
1 answer

ERROR 1045 (28000): Access denied for user in AWS.

Hi@akhtar, You need to reset the password for this. ...READ MORE

answered Apr 2, 2020 in AWS by MD
• 95,180 points
3,259 views
0 votes
1 answer

What is the difference between Amazon Athena and S3 Select?

Athena can be used by AWS Console, ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
7,188 views
0 votes
1 answer

What are the benefits of Migration?

Answering your second question first, Data Centers ...READ MORE

answered Jan 18, 2019 in AWS by Edureka
• 4,220 points
100 views