fuzing opened a new issue, #12765: URL: https://github.com/apache/iceberg/issues/12765
### Apache Iceberg version 1.8.1 (latest release) ### Query engine Spark ### Please describe the bug 🐞 This was originally issue [#3838](https://github.com/apache/iceberg/issues/3838), but the issue was closed without a fix in 2023. Calling remove_orphan_files still does not work with S3FileIO and has become an annoyance for anyone using iceberg with S3 file storage. We happen to be using ODBC to query through spark 3.5, connected to the thriftserver endpoint. ``` CALL system.remove_orphan_files( table => 'icebergdb.icebergtable', older_than => TIMESTAMP '2025-01-14T23:59:59.999Z', dry_run => false ); ``` This call fails with the following error message: ``` org.apache.hive.service.cli.HiveSQLException: Error running query: java.io.UncheckedIOException: org.apache.hadoop.fs.UnsupportedFileSystemException: No FileSystem for scheme "s3" at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQ' ``` Is there any workaround for this? ### Willingness to contribute - [ ] I can contribute a fix for this bug independently - [ ] I would be willing to contribute a fix for this bug with guidance from the Iceberg community - [ ] I cannot contribute a fix for this bug at this time -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
