I have `registertemptable` in `Apache Spark` using `Zeppelin` below:

```
val hvacText = sc.textFile("...")

case class Hvac(date: String, time: String, targettemp: Integer, actualtemp: Integer, buildingID: String)

val hvac = hvacText.map(s => s.split(",")).filter(s => s(0) != "Date").map(
    s => Hvac(s(0), 
            s(1),
            s(2).toInt,
            s(3).toInt,
            s(6))).toDF()

hvac.registerTempTable("hvac")

```

After I have done with my queries with this temp table, how do I remove it ?

I checked all docs and it seems I am getting nowhere.

Any guidance ?
['https://Stackoverflow.com/questions/32376066', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/5296786/']
If you want to remove your temp table on zeppelin, try like this.

```
sqlc.dropTempTable("hvac")

```

or

```
%sql DROP VIEW hvac

```

And you can get the informations you need from spark API Docs(<http://spark.apache.org/docs/latest/api/scala/index.html#org.apache.spark.package>)
You can use sql drop table/view statement to remove it like below

```
spark.sql("drop view hvac");

```