Apache Spark Quick Start Guide

Global temporary views on DataFrames

Temporary views only last for the session in which they are created. If we want to have views available across various sessions, we need to create Global Temporary Views. The view definition is stored in the default database, global_temp. Once a view is created, we need to use the fully qualified name to access it in a query:

//Scalasales_df.createGlobalTempView("sales")// Global temporary view is tied to a system database `global_temp`spark.sql("SELECT * FROM global_temp.sales").show()spark.newSession().sql("SELECT * FROM global_temp.sales").show()//Javasales_df.createGlobalTempView("sales");spark.sql("SELECT * FROM global_temp.sales").show();spark.newSession().sql("SELECT * FROM global_temp.sales").show(); ...