Athena Interface - Create Tables and Run Queries

From the services menu type Athena and go to the console. Once on the Athena console click on Set up a query result location in Amazon S3 and enter the S3 bucket name from Cloudformation output. S3 url in Athena requires a "/" at the end. Make sure to enter "/" at the end of the bucket location for the query results. Click on Saved Queries and Select Athena_create_amazon_reviews_tsv Click on Run query to create the table.
Click on Saved Queries and Select Athena_create_amazon_reviews_parquet and select the table create query and run the the query. Make sure to select one query at a time and run it. Once the query completes it will display a message to add partitions.
Run the next query to add partitions.
Next query will display the partitions.

Now that we have the tables created we will run some queries to test the performance between the tables:
Open Saved Queries and select Athena_compare_reviews
Run the queries in order and see the difference in amount of data scanned and time taken:

Query Table Time Taken Data Scanned
Top Ten Products By Avg Reviews amazon_reviews_tsv 2 min 1 sec 32.23 GB
Top Ten Products By Avg Reviews amazon_reviews_parquet 7.88 sec 6.34 GB
Top Ten Products By Avg Reviews in Mobile Apps category amazon_reviews_tsv 1 minute 32 seconds 32.21 GB
Top Ten Products By Avg Reviews in Mobile Apps category amazon_reviews_parquet 3.94 seconds 57.01 MB