def drop_table_or_view(
self,
name: str,
database: str | None = None,
force: bool = False,
) -> None:
"""Drop a Spark table or view.
Parameters
----------
name
Table or view name
database
Database name
force
Database may throw exception if table does not exist
Examples
--------
>>> table = 'my_table'
>>> db = 'operations'
>>> con.drop_table_or_view(table, db, force=True) # doctest: +SKIP
"""
statement = DropTable(name, database=database, must_exist=not force)
self.raw_sql(statement.compile())
def drop_table_or_view(self, name, database=None, force=False):
"""
Drop a Spark table or view
Parameters
----------
name : string
database : string, default None (optional)
force : boolean, default False
Database may throw exception if table does not exist
Examples
--------
>>> table = 'my_table'
>>> db = 'operations'
>>> con.drop_table_or_view(table, db, force=True) # doctest: +SKIP
"""
statement = DropTable(name, database=database, must_exist=not force)
self._execute(statement.compile())
def test_drop_table_compile():
statement = DropTable('foo', database='bar', must_exist=True)
query = statement.compile()
expected = "DROP TABLE bar.`foo`"
assert query == expected
statement = DropTable('foo', database='bar', must_exist=False)
query = statement.compile()
expected = "DROP TABLE IF EXISTS bar.`foo`"
assert query == expected
def drop_table(self, table_name, database=None, force=False):
"""
Drop an Impala table
Parameters
----------
table_name : string
database : string, default None (optional)
force : boolean, default False
Database may throw exception if table does not exist
Examples
--------
>>> table = 'my_table'
>>> db = 'operations'
>>> con.drop_table(table, database=db, force=True) # doctest: +SKIP
"""
statement = DropTable(
table_name, database=database, must_exist=not force
)
self.raw_sql(statement)