1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Spark SQL in Python

Exercise

Practice query plans

A dataframe text_df is available. This dataframe is registered as a table called table1.

Instructions

100 XP
  • Run explain on text_df.
  • Run explain on a SQL query that does a "SELECT COUNT(*) as count" on table1.
  • Run explain on a SQL query that counts the number of unique words in table1.