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,910 points
55 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,120 points
69 views
0 votes
1 answer

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,120 points
955 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
380 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
32 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
17 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.