framework/resources/Functional/cttas/crt_drp_recrt.sql

CREATE TEMPORARY TABLE dfs.tmp.tmp_tbl_4drp_c AS SELECT * FROM typeall_l;
DROP TABLE dfs.tmp.tmp_tbl_4drp_c;
CREATE TEMPORARY TABLE dfs.tmp.tmp_tbl_4drp_c AS SELECT * FROM typeall_l;
SELECT COUNT(*) FROM dfs.tmp.tmp_tbl_4drp_c;
DROP TABLE dfs.tmp.tmp_tbl_4drp_c;