I am trying to understand what is difference between AWS Athena service and the newly released S3 select (still in preview).
How are use cases different for both of those? It seems both help in selecting partial data from S3.
Also looks like we are missing one major thing:
S3 Select operates on only one object while Athena to run queries across multiple paths, which will include all files within that path.
You can think about AWS S3 Select as a cost-efficient storage optimization that allows retrieving data that matches the predicate in S3 and glacier aka push down filtering.
AWS Athena is fully managed analytical service that allows running arbitrary ANSI SQL compliant queries - group by, having, window and geo functions, SQL DDL and DML.
Athena is (from the little I've used it) more intended as a business reporting or analysis tool backed by S3.
S3 select appears to use the same sort of technology, but I would guess it's aimed more at direct use by applications to filter or shard their data sets.