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:
