CSDNWeiZhiQiang的博客

--dw跑的表 select * from( select 'ACPT_OCCUR_BILL_DETAIL' as n ,count(1) as c from ACPT_OCCUR_BILL_DETAIL -- where union all select 'ACPT_BALANCE_BILL_DETAIL' as n ,count(1) as c from ACPT_BALANCE_BILL...

select s.pre::numeric+s.row,test.* from test left join ( select to_char(now(),'yyyyMMddmmss000') pre,row_number() over(order by c1,c2,c3,c4,c5) row,c1||c2||c3||c4||c5 as t1 from test group by c1,c2,c...

删除是可以的，但是创建时就不行了 drop EXTERNAL table if exists eeee