drop_global_temp_view: Temporary View

In catalog: Access the 'Spark Catalog' API via 'sparklyr'

Temporary View

Description

• drop_global_temp_view(): Drops the global temporary view with the given view name in the catalog.

• drop_temp_view(): Drops the local temporary view with the given view name in the catalog. Local temporary view is session-scoped. Its lifetime is the lifetime of the session that created it, i.e. it will be automatically dropped when the session terminates. It's not tied to any databases.

Usage

drop_global_temp_view(sc, view)

drop_temp_view(sc, view)

Arguments

sc	A spark_connection.
view	character(1). The name of the temporary view to be dropped.

Value

A logical(1) vector indicating whether the temporary view was dropped (TRUE) or not (FALSE).

See Also

list_tables()

Examples

## Not run: 
sc <- sparklyr::spark_connect(master = "local")
mtcars_spark <- sparklyr::copy_to(dest = sc, df = mtcars)

# We can check which temporary tables are in scope
list_tables(sc = sc)

# And then drop those we wish to drop
drop_temp_view(sc = sc, view = "mtcars")

## End(Not run)

catalog documentation built on Aug. 23, 2022, 1:07 a.m.