Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bean
Contributor III
Contributor III

Using Parquet format with AWS Athena

Hi there

Is there a way I can use the (hopefully) better performing parquet format when querying AWS Athena?

So far I have configured Athena such it produces parquet result sets instead of CSV.

Now I would like to querry from my load script using e.g.

UNLOAD (SELECT * FROM "sydt"."pdi_mv")
TO 's3://XXXXi-athena-20240YYY094842531700000001/parquet/'
WITH (format='PARQUET');

but the Qlik SQL does not allow using other statements than select.

Any ideas how to query Athena and retrieving results in the parquet format?

Thanks so much!

Labels (2)
0 Replies