ming12713 commented on issue #7709: URL: https://github.com/apache/iceberg/issues/7709#issuecomment-2029217628
> > > > Is there anyone who solved this issue? > > > > > > > > > Try to add env variable to the rest container: `CATALOG_S3_PATH__STYLE__ACCESS: true` > > > It'll be [converted](https://github.com/tabular-io/iceberg-rest-image/blob/2e4d04184e6db38f23a98498151aa18bb6c148ab/src/main/java/org/apache/iceberg/rest/RESTCatalogServer.java#L54) to `s3.path-style-access=true` when the catalog is created and passed to [S3FileIO ](https://github.com/apache/iceberg/blob/43c3397528101859250160f123a0749bae79fb4d/aws/src/main/java/org/apache/iceberg/aws/s3/S3FileIOProperties.java#L178) > > > @sg-c0de > > > Can the jdbc catalog be configured like this? > > @ming12713 Sure, you can do it by passing this parameter in the config of ETL tool you use. For spark in spark-defaults.conf it will be like: spark.sql.catalog.catalof_name.s3.path-style-access true > > Full listing > > ``` > spark.sql.extensions org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions > spark.sql.catalog.demo org.apache.iceberg.spark.SparkCatalog > spark.sql.catalog.demo.type jdbc > spark.sql.catalog.demo.uri jdbc:postgresql://192.168.0.16:5432/jdbc_catalog_test > spark.sql.catalog.demo.jdbc.verifyServerCertificate false > spark.sql.catalog.demo.jdbc.useSSL false > spark.sql.catalog.demo.jdbc.user jdbc > spark.sql.catalog.demo.jdbc.password pass > spark.sql.catalog.demo.io-impl org.apache.iceberg.aws.s3.S3FileIO > spark.sql.catalog.demo.warehouse s3://iceberg-test-jdbc/ > spark.sql.catalog.demo.s3.endpoint https://minio.example.com > spark.sql.catalog.demo.s3.path-style-access true > spark.sql.defaultCatalog demo > spark.eventLog.enabled true > spark.eventLog.dir /home/iceberg/spark-events > spark.history.fs.logDirectory /home/iceberg/spark-events > spark.sql.catalogImplementation in-memory > ``` > > For trino it will be **s3.path-style-access** in the catalog properties https://trino.io/docs/current/object-storage/file-system-s3.html @sg-c0de it's work thanks -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org For additional commands, e-mail: issues-h...@iceberg.apache.org
