What does the command df registerTempTable do

Question

What does this command does, is to just register an empty table with no columns?

df.registerTempTable(“airports”)  

I read a csv file with test data I got the message that the table is being stored in HiveMetaStore. Is it a correct understanding that the way we created the table is not a Spark Temp View but a Hive table? If so, can we change the path of the HiveMetastore to a different value where I am keeping other Hive Tables?

Also, when I say show table, now I see that against "sal2" table "isTemporary" is set to False. Does this mean that this table will be available even to other sessions plus will be there even I close the session?

Answer 1

df.registerTempTable(“airports”) 

This command is used to register the dataframe df as a temporary table airports so that we are able to query the table.

Here, df is a dataframe which you need to create and airports are the temporary table.

you are getting an error in the screenshot. Please refer to the below screenshot:

Also, yes if temporary is set to false, means that the table will be available even after you close the session. The table is not temporary.