pyspark.sql.DataFrame.createGlobalTempView¶

DataFrame.createGlobalTempView(name: str) → None[source]¶

Creates a global temporary view with this DataFrame.

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

New in version 2.1.0.

Changed in version 3.4.0: Supports Spark Connect.

Parameters

namestr: Name of the view.

Examples

Create 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")
>>> sorted(df.collect()) == sorted(df2.collect())
True

Throws an exception if the global temporary view already exists.

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

pyspark.sql.DataFrame.cov pyspark.sql.DataFrame.createOrReplaceGlobalTempView