Caches contents of a table or output of a query with the given storage level in Apache Spark cache. If a query is cached, then a temp view is created for this query. This reduces scanning of the original files in future queries.
CACHE [ LAZY ] TABLE table_name [ OPTIONS ( 'storageLevel' [ = ] value ) ] [ [ AS ] query ]
See Delta and Apache Spark caching for the differences between the Delta cache and the Apache Spark cache.
Only cache the table when it is first used, instead of immediately.
Identifies the Delta table or view to cache. The name must not include a temporal specification.
OPTIONS ( ‘storageLevel’ [ = ] value )
storageLevelkey and value pair. A warning is issued when a key other than
storageLevelis used. The valid options for
An Exception is thrown when an invalid value is set for
storageLevelis not explicitly set using
OPTIONSclause, the default
storageLevelis set to
A query that produces the rows to be cached. It can be in one of following formats: