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!