Deleting namespaces and tables of JDBC Catalog

[ArijitSinghEDA]

Question

I have a catalog created with a Postgres+Minio. When I run the function catalog.drop_namespace(), the namespace with its properties (if any), do not get purged from the Postgres. When I run the function catalog.drop_table(), it does the same thing, and the data is not purged from the Minio as well.

Is this a known behaviour?

[kevinjqliu]

drop_namespace and drop_table are metadata operations. in this case, they will remove the specific entries in the postgres database.

for drop_table, some catalog implementations also support removing the underlying files associated with the table. for example

iceberg-python/pyiceberg/catalog/rest.py

Lines 706 to 716 in df804c4

	def drop_table(self, identifier: Union[str, Identifier], purge_requested: bool = False) -> None:
	identifier_tuple = self._identifier_to_tuple_without_catalog(identifier)
	response = self._session.delete(
	self.url(
	Endpoints.drop_table, prefixed=True, purge=purge_requested, **self._split_identifier_for_path(identifier_tuple)
	),
	)
	try:
	response.raise_for_status()
	except HTTPError as exc:
	self._handle_non_200_response(exc, {404: NoSuchTableError})

for catalogs which subclass MetastoreCatalog like SqlCatalog there is a purge_table function available to remove the files