'How to write presto query output to s3 on emr cluster?

I want to write Presto query output from EMR cluster to S3 location. I performing below command but it is not working. Do I need to change any configs on EMR cluster for this?

INSERT INTO DIRECTORY 's3n://test-bucket/manoj/presto-query-output/' 
select logdate from hive.core.candidates_orc_hr  s WHERE logdate = '2022-05-12' AND loghour = '21'; 


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source