gengliangwang commented on PR #53401:
URL: https://github.com/apache/spark/pull/53401#issuecomment-3633666328
@yyanyy let's update the doc for cache table/uncache table as well
```
sql-ref-syntax-aux-cache-cache-table.md:title: CACHE TABLE
sql-ref-syntax-aux-cache-cache-table.md:displayTitle: CACHE TABLE
sql-ref-syntax-aux-cache-cache-table.md:`CACHE TABLE` statement caches
contents of a table or output of a query with the given storage level. If a
query is cached, then a temp view will be created for this query.
sql-ref-syntax-aux-cache-cache-table.md:CACHE TABLE testCache OPTIONS
('storageLevel' 'DISK_ONLY') SELECT * FROM testData;
sql-ref-syntax-aux-cache-refresh.md:CACHE TABLE test;
sql-ref-syntax-aux-cache-uncache-table.md:title: UNCACHE TABLE
sql-ref-syntax-aux-cache-uncache-table.md:displayTitle: UNCACHE TABLE
sql-ref-syntax-aux-cache-uncache-table.md:`UNCACHE TABLE` removes the
entries and associated data from the in-memory and/or on-disk cache for a given
table or view. The
sql-ref-syntax-aux-cache-uncache-table.md:underlying entries should already
have been brought to cache by previous `CACHE TABLE` operation. `UNCACHE TABLE`
on a non-existent table throws an exception if `IF EXISTS` is not specified.
sql-ref-syntax-aux-cache-uncache-table.md:UNCACHE TABLE [ IF EXISTS ]
table_identifier
sql-ref-syntax-aux-cache-uncache-table.md:UNCACHE TABLE t1;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
