What is Athena ?? How its Works ??

Index:

1. setup Athena

2. Create & Select database

3. Create table

4. Load data in table 

5. over of query running

Pre-required :

Know about Hive and s3

-  Its similar to Hive but it is server less 

- Athena is layer on top of hive 

- No server required 

- as similar to hive in input data no header required

- In Athena 

- No charge on DDL Commands (Data Definition Language)

- It charge on scanning data only it's minimum 10mb 

- Athena used or work on external table 

Note:

'skip.header.line.count'='1'   # for the skip header line 

Video Link : https://www.youtube.com/watch?v=TzlN-aXKc_w

Video: