'Is it possible to run AWS Athena on an S3 that has files from two different formats?
I have an S3 that has a long list of files in two different formats! CSV files that contain the word "log" have 10 columns, and CSV files that contain the word "sever" have 20 columns (The variables are also different)
Is it possible to run with Athena on S3 and query only the "log" files? and if so, how to do that?
Solution 1:[1]
No, Athena will read all files in the table's (or each partition's) LOCATION. There is no way to configure it to read only some files.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Theo |