https://community.cloudera.com/t5/Support-Questions/Issue-creating-accessing-hive-external-table-with-s3/m-p/375511#M242488 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/63922">@sam_kalmesh</a>&nbsp;- Were you able to get a resolution for the error posted. We are hitting similar access error when trying to create a table from hive shell using s3a path i.e (s3a://bucket1/test_data_table) :</P><P>&nbsp;</P><P>Caused by: com.amazonaws.services.s3.model.AmazonS3Exception: Forbidden (Service: Amazon S3; Status Code: 403</P><P>Caused by: java.nio.file.AccessDeniedException: s3a://bucket1/test_data_table: getFileStatus on s3a://bucket1/test_data_table</P><P>&nbsp;</P><P>If the external path is changed to o3fs style to the same bucket then the tables get successfully created but fails with s3a path style.</P><P>&nbsp;</P><P>The following config settings were added to "<SPAN>Hive Service Advanced Configuration Snippet (Safety Valve) for core-site.xml" as well :</SPAN></P><P>&nbsp;</P><P><SPAN>fs.s3a.bucket.bucket1.access.key</SPAN></P><P><SPAN>fs.s3a.impl</SPAN></P><P><SPAN>fs.s3a.bucket.bucket1.secret.key</SPAN></P><P><SPAN>fs.s3a.endpoint</SPAN></P><P><SPAN>fs.s3a.bucket.probe</SPAN></P><P><SPAN>fs.s3a.change.detection.version.required</SPAN></P><P><SPAN>fs.s3a.path.style.access</SPAN></P><P><SPAN>fs.s3a.change.detection.mode</SPAN></P><P>&nbsp;</P> Wed, 23 Aug 2023 12:10:26 GMT skommineni 2023-08-23T12:10:26Z