问如何清除星火库中的临时视图缓存

EN

CREATE TEMPORARY VIEW temp_view_1 AS
    SELECT
        column1,
        column2
    FROM  Table1;
CACHE TABLE temp_view_1;

CREATE TEMPORARY VIEW temp_view_2 AS
    SELECT
    /*+ BROADCAST(b) */
        a.column1,
        a.column2
  FROM  Table2 a JOIN temp_view_1 b ON a.column1 = b.column1 ;


CREATE TEMPORARY VIEW temp_view_3 AS
    SELECT
    /*+ BROADCAST(b) */
        a.column1,
        a.column2
  FROM  Table3 a JOIN temp_view_1 b ON a.column1 = b.column1 ;

DROP TABLE temp_view_1; -- Does this  statement clear the cache as well ? If not, how can I clear cache ?

SELECT
        a.column1,
        a.column2
  FROM  temp_view_2 a JOIN temp_view_3 b ON a.column1 = b.column1 ;