How to convert a table into a Spark Dataframe

Question

In Spark SQL, a dataframe can be queried as a table using this:

sqlContext.registerDataFrameAsTable(df, "mytable")

Assuming what I have is mytable, how can I get or access this as a DataFrame?

Answer 1

The cleanest way:

df = sqlContext.table("mytable")

Documentation