cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Cache Select on Temp Table?

auser85
New Contributor III

How might I cache a temp table?

The documentation suggests it is possible: https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-cache.html

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> ]`

1 ACCEPTED SOLUTION

Accepted Solutions
4 REPLIES 4

Prabakar
Esteemed Contributor III
Esteemed Contributor III

Kaniz
Community Manager
Community Manager

Hi @Andrew Fogartyโ€‹ , Just a friendly follow-up. Do you still need help, or @Prabakar Ammeappinโ€‹'s response help you to find the solution? Please let us know.

auser85
New Contributor III

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

Kaniz
Community Manager
Community Manager

@Andrew Fogartyโ€‹ , Awesome!

I'm glad we were able to resolve your problem. Thank you for marking the best answer, though!