qua_evict_spark_inmem_cached_table

The procedure removes data from Apache Spark in-memory cache for a given table. It works only for views with in-memory caching configured. If the data for a given table is not cached, no action performed.

Syntax

qua_evict_spark_inmem_cached_table 'tableName' [;]

Arguments

‘tableName’

Fully qualified name of view which data is to removed from the in-memory cache.

Example

Example code clears in-memory cache for the view AdventureWorksDW2012.dbo.DimCurrency cached on Apache Spark.

EXEC qua_evict_spark_inmem_cached_table @tableName = 'AdventureWorksDW2012.dbo.DimCurrency';