You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "ajantha-bhat (via GitHub)" <gi...@apache.org> on 2023/02/09 08:05:05 UTC

[GitHub] [iceberg] ajantha-bhat opened a new issue, #6785: Support Unregister table CALL procedure

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-unsubscribe@iceberg.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] github-actions[bot] commented on issue #6785: Support Unregister table CALL procedure

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6785:
URL: https://github.com/apache/iceberg/issues/6785#issuecomment-1670471928

   This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.


-- 
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-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


Re: [I] Support Unregister table CALL procedure [iceberg]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6785:
URL: https://github.com/apache/iceberg/issues/6785#issuecomment-1883991127

   This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'


-- 
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-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


Re: [I] Support Unregister table CALL procedure [iceberg]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #6785: Support Unregister table CALL procedure
URL: https://github.com/apache/iceberg/issues/6785


-- 
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-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org