pyspark.sql.DataFrame.registerTempTable

DataFrame.registerTempTable(name)[source]

Registers this DataFrame as a temporary table using the given name.

The lifetime of this temporary table is tied to the SparkSession that was used to create this DataFrame.

New in version 1.3.0.

Deprecated since version 2.0.0: Use DataFrame.createOrReplaceTempView() instead.

Examples

>>> df.registerTempTable("people")
>>> df2 = spark.sql("select * from people")
>>> sorted(df.collect()) == sorted(df2.collect())
True
>>> spark.catalog.dropTempView("people")