topic Re: Cache Select on Temp Table? in Data Engineering

Cache Select on Temp Table?

auser85 — Wed, 01 Jun 2022 18:13:03 GMT

How might I cache a temp table?

Consider the following on DBR 10.5 and Spark 3.2.1:

```

%python

df.createOrReplaceTempView("changeset");

```

CACHE SELECT * from changeset

```

`CACHE supports only SELECT queries with optional WHERE clause, e.g. CACHE SELECT <columns> FROM <table> [ WHERE <predicate> ]`

Prabakar — Thu, 02 Jun 2022 10:12:31 GMT

@Andrew Fogarty , Please check if the doc helps you.

auser85 — Fri, 03 Jun 2022 15:35:21 GMT

Thank you! The newer documentation does indeed work for me.