Question

Which of these code snippet is the correct format to run SQL queries? 

(i)display(spark.sqlContext("select * from Fresco")) 

(ii)print(spark.sql("select * from Fresco")) 

(iii)display(spark.sql("select * from Fresco")) 

(iv)show(spark.sql("select * from Fresco")) 

Answer 1

display(spark.sql("select * from Fresco")) 

Answer 2

https://madanswer.com/2011/which-code-snippet-correct-format-run-sql-queries