Query failed: External location must be a directory

[nareshurs]

Hello,

We are using a custom on prem storage which is supposed to work similar to S3. We deployed presto on Kubernetes which uses hive metastore and trying to create a table on the custom S3 storage.

I have updated all hive properties including access key, secret key and end point url..etc. However when we try to create a table programmatically/via presto CLI, I see the error 'Query failed: External location must be a directory'.
Same access works fine with spark and I am able to write data using spark.

Below are hive properties used.

hive.s3.aws-access-key=

hive.s3.aws-secret-key=<key>

hive.s3.endpoint=[<end point>)

hive.s3.path-style-access=true

hive.s3.signer-type=AWSS3V4SignerType

hive.s3.ssl.enabled=false

hive.s3.iam-role=

hive.s3.use-instance-credentials=false

hive.s3select-pushdown.enabled=true

Any pointers or help is greatly appreciated to fix above issue