ajantha-bhat opened a new issue, #6785: URL: https://github.com/apache/iceberg/issues/6785
### Feature Request / Improvement Multiple times users have run into a scenario where they had accidentally deleted the table files from storage but they cannot drop the table from catalog. a) User cannot use "Drop Table SQL", as even though purge is false, this command tries to load the table metadata. ``` at org.apache.iceberg.spark.SparkCatalog.loadTable(SparkCatalog.java:146) at org.apache.spark.sql.connector.catalog.CatalogV2Util$.loadTable(CatalogV2Util.scala:311) ``` b) Only way to drop this table from catalog is using catalog java API. But users want to handle this scenario from SQL itself without a custom code. Hence, need a call procedure that just removes the table entry from the catalog without looking up the files. slack thread: https://apache-iceberg.slack.com/archives/C025PH0G1D4/p1670216247466289?thread_ts=1669969537.253849&cid=C025PH0G1D4 ### Query engine Spark -- 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.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
