IniziaInizia gratis

Caching and uncaching tables

In the lesson we learned that tables can be cached. Whereas a dataframe is cached using a cache or persist operation, a table is cached using a cacheTable operation.

A table called table1 is available.

Questo esercizio fa parte del corso

Introduction to Spark SQL in Python

Visualizza il corso

Istruzioni dell'esercizio

  • List the tables with the listTables() method.
  • Cache table1 and confirm that it is cached.
  • Uncache table1 and confirm that it is uncached.

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

# List the tables
print("Tables:\n", spark.____.____())

# Cache table1 and Confirm that it is cached
spark.catalog.____('table1')
print("table1 is cached: ", spark.catalog.____('table1'))

# Uncache table1 and confirm that it is uncached
spark.catalog.____('table1')
print("table1 is cached: ", spark.catalog.____('table1'))
Modifica ed esegui il codice