复制表结构
create table relation_tmp1(like relation INCLUDING all) DISTRIBUTED BY (converid) ;
查看正在执行的sql:注意差异性
select * from pg_stat_activity where xact_start is not null ORDER BY query_start;
复制表结构
create table relation_tmp1(like relation INCLUDING all) DISTRIBUTED BY (converid) ;
查看正在执行的sql:注意差异性
select * from pg_stat_activity where xact_start is not null ORDER BY query_start;
本文标题:GP 常用操作
本文链接:https://www.haomeiwen.com/subject/jyuvaltx.html
网友评论