Answer-first summary for fast verification
Answer: Temporary views in Spark SQL are session-scoped and cannot be accessed from different sessions.
Temporary views in Spark SQL are session-scoped, meaning they only exist for the duration of the session in which they were created. This design ensures that temporary views are used for transient, session-specific tasks without consuming resources beyond their intended scope. For views that need to be accessed across sessions, consider using a global temporary view instead.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Why can't a data engineer access a temporary view created in one Spark SQL session from another session?
A
Temporary views are automatically deleted after a certain period, and the time limit was exceeded.
B
The network connection between the two Spark sessions was lost, preventing access to the temporary view.
C
Temporary views in Spark SQL are session-scoped and cannot be accessed from different sessions.
D
The data engineer did not correctly create the temporary view, resulting in an error when trying to access it from another session.
E
Temporary views require special permissions to be accessed from different sessions.
No comments yet.