1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
-1
Hello,
The below Athena UNLOAD query with the WITH clause worked fine for me.
UNLOAD(select * from table)
to 's3://bucket/'
with(format='parquet',compression='snappy')
You can find some examples here
Contenus pertinents
- demandé il y a 2 mois
- Réponse acceptéedemandé il y a un an
- demandé il y a un an
AWS OFFICIELA mis à jour il y a 4 mois- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
Thanks for your answer, but I mean the "classic" SQL WITH clause (for aliasing whole queries), not the with clause for adding the UNLOAD options.
Something like:
WITH table1 as (SELECT raw.field1, raw.field2, raw2.field1, raw2.field1 from raw, raw2 ....), table2 as (SELECT raw3.field1, raw3.field2, raw3.field3 from raw3) UNLOAD (SELECT * from table1, table2 ....) to 's3://bucket/' with(format='parquet',compression='snappy')