Skip to contents
  • 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

Examples

if (FALSE) {
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")
}