Skip to main content

Posts

Showing posts from December, 2019

Starting with Amazon Athena

Hi All! Its long since I have offered my readers something  technical to go through. The wait is over and its really worth it. We will dive into  cloud  today. I will be explaining you in details how can you use one of the popular service of AWS known as  Athena . The blog is written keeping in mind that you have little or no idea about any AWS service. Albeit, a tad bit of knowledge on  S3  service will help you to understand the blog better. Lets take an use case before proceeding ahead. Suppose we have a csv file that contains some data into it. lets say it has details of Employees in a company. I have another csv file that contains details of the department of a company. Now, I wish to do some operations that needs data from the employee file and department file to be joined. e.g to get max salary of employee in every department etc. If we had the same data in 2 tables in a database, things had been simple. right? We could have just joined both the tables, grouped on depart