temp-tables - 如何在 redshift 中创建和调用临时表

Question

我想创建一个临时表并在 redshift 中调用这个临时表？我试过这个，但收到一条错误消息。

select  top 10 * into #a from public.item_activity where item_act_timestamp < DATEADD(day,-1,getdate());

select * from #a

"ERROR: 42P01: relation "#a" does not exist"

Answer 1

您可以使用

Create temporary table tbl_name as (Select * from abc)
--OR
create temporary table tmp_date_var AS
( SELECT '2017-04-01'::Date AS stdt,'2018-01-31'::Date AS enddt);