pyspark.sql.DataFrame.createGlobalTempView#

DataFrame.createGlobalTempView(name)[source]#

Creates a global temporary view with this DataFrame.

New in version 2.1.0.

Changed in version 3.4.0: Supports Spark Connect.

Parameters

namestr: Name of the view.

Notes

The lifetime of this temporary view is tied to this Spark application. throws TempTableAlreadyExistsException, if the view name already exists in the catalog.

Examples

Example 1: Creating and querying a global temporary view

>>> df = spark.createDataFrame([(2, "Alice"), (5, "Bob")], schema=["age", "name"])
>>> df.createGlobalTempView("people")
>>> df2 = spark.sql("SELECT * FROM global_temp.people")
>>> df2.show()
+---+-----+
|age| name|
+---+-----+
|  2|Alice|
|  5|  Bob|
+---+-----+

Example 2: Attempting to create a duplicate global temporary view

>>> df.createGlobalTempView("people")  
Traceback (most recent call last):
...
AnalysisException: "Temporary table 'people' already exists;"

Example 3: Dropping a global temporary view

>>> spark.catalog.dropGlobalTempView("people")
True