Answer-first summary for fast verification
Answer: df.createOrReplaceTempView('sales_view')
The correct answer is A because it correctly uses the 'createOrReplaceTempView' method to create a temporary view named 'sales_view' that can be used in subsequent SQL queries. This method ensures that the view is always up-to-date with the DataFrame.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Assume you have a DataFrame df loaded from a CSV file located at '/data/sales.csv' with columns 'id', 'product', 'quantity', and 'price'. You need to create a temporary view named 'sales_view' that can be used in subsequent SQL queries. How would you achieve this using PySpark?
A
df.createOrReplaceTempView('sales_view')
B
df.createTempView('sales_view')
C
df.createOrReplaceGlobalTempView('sales_view')
D
df.createGlobalTempView('sales_view')