df.persist
df.show(df.count, false) // in Scala or 'False' in Python
Here is what the above code is Doing:
1. Creating a DataFrame from a list of tuples
2. Registering the DataFrame as a table
3. Running a SQL query against the table
4. The result of the query is another DataFrame
5. We call an action on this DataFrame to see the contents