drop_global_temp_view {catalog}

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)