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 in AWS by Anjali
• 2,930 points
149 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 by Edureka
• 4,180 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 by Edureka
• 4,180 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
• 56,520 points
156 views
0 votes
2 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
• 56,520 points
1,656 views
0 votes
1 answer

What is the difference between Amazon SNS and Amazon SQS?

SNS is a distributed publish-subscribe system and the messages are pushed to ...READ MORE

answered Jul 30, 2018 in AWS by Mrunal
• 680 points
626 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
41 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What are the benefits of Migration?

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

answered Jan 18 in AWS by Edureka
• 4,180 points
25 views