Which of the following code blocks uses SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF?
A.
storesDF.createOrReplaceTempView() spark.sql("SELECT storeId, managerName FROM stores")
B.
storesDF.query(”SELECT storeid, managerName from stores")
C.
spark.createOrReplaceTempView("storesDF") storesDF.sql("SELECT storeId, managerName from stores")
D.
storesDF.createOrReplaceTempView("stores") spark.sql("SELECT storeId, managerName FROM stores")
E.
storesDF.createOrReplaceTempView("stores") storesDF.query("SELECT storeId, managerName FROM stores")
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sowwy1
7 months, 2 weeks ago